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 ...
Hi Greg_Deckler and thanks for the reply.
The default application for opening csv files is set to MS Excel. Because of this the exported data file is opened directly with Excel and the cyrrilic letters are shown as gibberish.
I was thinking of setting the default csv application to Notepad, then the users could copy the text lines (all but the first), open Excel and from Paste->Use Text Import Wizzard paste the text into the sheet. Unfortunately I am sure the users will not like it.
Yeah, understood, either way it is fairly complex for the user versus "double-click the file". Not sure of a way around it short of writing VBA code of some sort.