Forum Discussion

jaryszek's avatar
jaryszek
Super User
1 year ago
Solved

Export data strange characters

hi, after exporting table from visual into csv data i am getting strange characters like:   What is the cause? Best, Jacek  
Need Help
  • v-lgarikapat's avatar
    v-lgarikapat
    1 year ago

    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

jaryszek's avatar
jaryszek
Super User
1 year ago

thanks, if this File Origin to 65001: Unicode is usual format while power bi exporting data? 
Can i change this also in power bi ?

Best,
Jacek

v-lgarikapat's avatar
v-lgarikapat
Community Support
1 year ago

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