Export data strange characters

Hi jaryszek ,

Thanks for the follow-up questions

This issue happens because Excel especially older versions or those in non-English languages often defaults to opening files using ANSI or a different encoding. When that happens, special characters like the Euro sign (€) can be misinterpreted, showing up as strange symbols like €. On the other hand, Power BI always exports CSV files using UTF-8 encoding by default, specifically without a BOM (Byte Order Mark), which helps with compatibility in many systems but can confuse Excel. Unfortunately, Power BI doesn’t currently offer a way to change the export encoding. There’s no setting in either Power BI Desktop or the Power BI Service that lets you export with ANSI or include a BOM in UTF-8 files.

Hope this is helpful.

Thank you for being an active member of the community.

Best regards,
Lakshmi Narayana