Forum Discussion

Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

Export to Excel - UTF-8

Hi   Our end users are complaining that when they export data from PowerBI and open it in Excel, the text with cyrillic letters is not readable. This is due to the fact that the export is in UTF-8 ...
Need Help
Tsanka's avatar
Tsanka
Kudo Collector
10 years ago

Update - it seems currently the problem is solved. I am able to export data with cyrillic and to open them directly in Excel.

KamilG's avatar
KamilG
New Member
10 years ago

Three weeks ago, something was changed in csv file. Now line with "sep=," is deleted when enything is exported from Power BI. This mean that the file can't be open in Excel. It is always opening as a text not divided into column. User have to import data from text to Excel which is very annoying. How to change it that Excel will open the file as was before change?

  • SandySan21's avatar
    SandySan21
    New Member
    10 years ago

    I believe 'sep=' instruction was removed because it will make Excel to ignore the Byte Order Mark which breaks many scenarios.

     

    For your situation, you could workaround the issue by changing separator in windows control panel

     

    1. Click the Windows Start menu.
    2. Click Control Panel.
    3. Open the Regional and Language Options dialog box.
    4. Click the Regional Options Tab.
    5. Click Customize / Additional settings (Win10).
    6. Type a new separator (use comma) in the List separator box.
    7. Click OK twice.

     

     

  • SandySan21's avatar
    SandySan21
    New Member
    10 years ago

    I think sep= is removed because it cause Excel to ignore BOM in the file which caused other issues.

     

    For your scenario, you can change the list separator in Window.

    1. Click the Windows Start menu.
    2. Click Control Panel.
    3. Open the Regional and Language Options dialog box.
    4. Click the Regional Options Tab.
    5. Click Customize / Additional settings (Win10).
    6. Type a new separator (comma) in the List separator box.
    7. Click OK twice.