Power BI importing special characters as 0 (Unicode)

[waterplea]

Hello,

Power bi is importing unicode characters such as \u00e6 (æ) as 0. Is there a way to solve this? I have tried to change the encoding but this had no succes.

[v-xuding-msft]

Hi @waterplea ,

Could you tell me if your problem has been solved? If it is, kindly mark the helpful answer as a solution if you feel that makes sense. Welcome to share your own solution. More people will benefit from here.

Best Regards,

Xue Ding

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

[v-xuding-msft]

Hi @waterplea ,

Which encoding did you try? UTF-8? If your files are saved as .xls or .xlsx, please try to change them into .csv with encoding UTF-8. 

Or you could reference the blog: Using Unicode Characters in Power BI , maybe it can help you.

Best Regards,

Xue Ding

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

[amitchandak]

Check if these can help

https://techcommunity.microsoft.com/t5/excel/power-query-how-to-determine-remove-this-non-printable-...

https://community.powerbi.com/t5/Desktop/How-to-remove-nonessential-characters-such-as-punctuation/t...

https://community.powerbi.com/t5/Desktop/Can-t-remove-invisible-characters/td-p/105613