Forum Discussion
Power Query "accented character"
Good evening, everyone,
I need to receive your support.
Daily I process an Excel file (.xlxs) extracted from a procedure that involves accented characters (f.e. à).
Unfortunately, the Excel file reports a square in place of this character that Power Query does not "detect."
Is there any way to be able to replace/insert the special characters in PQ?
I have tried "find and replace" in the column but it is not possible to detect the "square" on PQ.
I tried looking for this topic in other discussions but I don't seem to have found anything similar.
In case I am wrong, please forgive this my first post.
I thank you in advance for your support.
2 Replies
You may try the solutions introduced in the following links:
How to set the csv file encoding? - Microsoft Power BI Community
Power BI is not correctly displaying special characters (country/region) | Proving Ground Apps
Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it. Highly appreciate your Kudos!Hi v-jingzhang, thank you so much for your support.
Unfortunally it doesn't work.
Some files are generated with the □ instead of "à". I created a very long elaboration with Power Query and the original file "enter" as "□". I cannot change the file into .cvs.
Do you know if there's some other ways to elaborate/convert the □ into a "a" or "à". I add that PQ doesn't show "□" on the columns, just if I open "the filter field".
Thank you in advance.
