When I import a text file to PowerPivot containing apostrophes, they are automatically converted to â€™.
I've been manually correcting the few that I find in the PowerPivot window, however when I do this in a column header it causes problems refreshing the data.
A quick Google tells me that â€™ often appears in place of apostrophes when there is a text encoding mismatch. It seems that I need to make sure PowerPivot is reading the data as UTF-8.
How can I do this in PowerPivot? I've tried searching online with no luck.