I have a .pbix file and load it into PowerBI desktop. I would like to the export data. The generated CSV file contains the delimiter comma.
1) How can I change in PowerBI desktop the delimiter for CSV file to semicolon?
2) How can I export the file as Excel XLSX? Is there a premium license required for PowerBI desktop? How can I gain this?
Solved! Go to Solution.
It is a long time later, but I have the same issue. Using amounts written with a , (110,12) And the CSV import to Excel sees this as a column separation.
I found a workaround and thought I could share it here:
Open the report online (app.powerbi.com).
Click on the ... top right corner of the visualisation you want to have in Excel.
Click on export data
Now you get a new screen that you don't get on the desktop power BI:
And this gives you the .xlsx you need!
The easiest way to change the data is to open the .csv file with notepad, notepad++, or any text editor of your choice, and then find-replace all , with ;
As far as exporting it as a .xlsx file, you can follow the instructions here, no special license needed: https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data
Thanks for your prompt reply. Unfortunately, I cannot replace the CSV file as some columns includes description texts (sentences) with the character ",". It would be better if the delimiter is a character which is rarely used in the content.
I do not have any export menu dialogues for Excel. Just see that a CSV file is generated.
hi, @Anonymous @Cmcmahan
As Cmcmahan said, using a regional delimiter instead of always using comma is a requested feature. You can vote for it here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15972523-export-to-csv-regional-s...
And in power bi desktop, you could only export data to CSV for now, it is not possible export data to xlsx.
You can vote for it here too:
Looks like using a regional delimiter instead of always using comma is a requested feature. You can vote for it here: https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/15972523-export-to-csv-regional-s... In the meantime, you may be able to edit your data in PBI to replace commas with another character before export as a workaround
You need a Pro license to export any data, so I'm assuming you already have that for the Excel format requirement. You can find the method to check your current license here
You can also check the limitations on exporting data here to see if any of those conditions apply and are preventing your .xlsx export.
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.
Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!
Join us Oct 1 - 6 in Las Vegas for the Microsoft Power Platform Conference.