Forum Discussion
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 ...
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?
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
- Click the Windows Start menu.
- Click Control Panel.
- Open the Regional and Language Options dialog box.
- Click the Regional Options Tab.
- Click Customize / Additional settings (Win10).
- Type a new separator (use comma) in the List separator box.
- Click OK twice.