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 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!
2 Replies
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?
Hi Anonymous ,
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.
