Transform file giving me wingdings

[NedFlanders]

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 table within the query edit, I get two columns full of wingdings.

There is nothing unusual in the source Excel file - just a file with one tab and about ten columns of data in text and numbers.  Any help on why I'm getting this mess?

Thank you!

[Anonymous]

Hi @NedFlanders ,

I’m sorry to hear that you encountered garbled characters after expanding data in Power Query. The problem might be related to encoding. Try saving your source file as a UTF-8 type file before importing it to Power Query.

Reference:

Garbled character on Excel 365 Power query - Microsoft Community

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.           

[HotChilli]

From 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?