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

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.

Greg_Deckler's avatar
Greg_Deckler
Community Champion
10 years ago

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.

  • sofi's avatar
    sofi
    New Member
    10 years ago

    Hi, we have bag that describe below:

    We get the first row the letters [sep=,] its prevent us to open file in excel as you instructed us.

    Thanks