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

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

Hi jaryszek ,

Thanks for reaching out to the Microsoft fabric community forum.

tharunkumarRTK 

Thanks for your prompt response

 In Addition to tharunkumarRTK ,  

Based on the screenshot you shared, here is the workaround

To open your exported CSV from Power BI without seeing strange characters like €, open Excel, go to the Data tab, choose Get Data > From Text/CSV, select your CSV file, and in the import dialog, set the File Origin to 65001: Unicode (UTF-8), then click Load this will ensure values like € 2.09 display correctly instead of corrupted symbols.

 

 

 

If you're still facing challenges, feel free to let us know we’ll be glad to assist you further.

Looking forward to your response.

Best regards,
LakshmiNarayana

 

 

 

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