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...
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.