Forum Discussion
Transform file giving me wingdings
Hi all - I'm a little new to Power Query. I was just trying to pull another Excel file into my file with a query. I've referenced the file fine but when I hit the Transform File to see the data tab...
HotChilli
Community Champion
Community ChampionFrom looking at it, either the wrong connection method is being used or
there is a different encoding in the Excel document. Power Query can use many encodings to load Excel or csv documents, usually it automatically picks common/the right one but it may not be right with this one.
---
Is there anything unusual about the source of this Excel doc? Does it contain international character sets? Can ypu post the Advanced Editor code here please?