Export data strange characters

[jaryszek]

hi,

after exporting table from visual into csv data i am getting strange characters like:

What is the cause?

Best,
Jacek

[v-lgarikapat]

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]

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 · Accepted solution]

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

[tharunkumarRTK]

@jaryszek 

Is there any format string applied to those measures? if yes can you share that format string?

[jaryszek]

Yes,

it is: