Forum Discussion
Resident RockstarExport data with semicolon (;) delimiter
Hi everyone,
We have a request to export data from Power BI in csv format, but to use ";" as delimiter, not ",".
Power BI itself doesn't have such option.
I wanted to test it in Power Automate, but still i can't find a solution for this.
Scenario
Output: csv file.
Columns: Country, City, Street.
Goal:
When i download the file and open in text editor (Notepad), it should be in this format:
Country;City;Street
And not:
Country,City,Street
Ideally: this export process should run every day.
Thank you in advance!
Cheers,
Nemanja
Hi everyone,
Thank you for replies and apologies for late answer.
As rohit1991 mentioned, i was searching for that option, to set ";" as delimiter, but i couldn't find it. After some research, ChatGPT confirmed there is no such option yet.
3. Add Data Operations >> Create CSV table >> Columns: Custom (map Country/City/Street) >> Delimiter: Semicolon (;).
I tested a few steps, finally, i've built Power Automate which works as expected.
It would be much easier if there was option to choose delimiter, however, at this point of time, there isn't such option on Power BI or Power Automate.
If anyone interested, here is my solution: https://data-trekking.com/2025/08/27/export-power-bi-data-with-semicolon-using-power-automate/
6 Replies
rohit1991Super User
Hi nandic
Power BI itself can’t change the CSV delimiter. Do it with Power Automate.Could you please follow the steps below:
1. In Power Automate, create a Scheduled cloud flow (run every day).2. Add Power BI >> Run a query against a dataset and use a simple DAX query:
EVALUATE SELECTCOLUMNS('YourTable', "Country", 'YourTable'[Country], "City", 'YourTable'[City], "Street", 'YourTable'[Street] )3. Add Data Operations >> Create CSV table >> Columns: Custom (map Country/City/Street) >> Delimiter: Semicolon (;).
4. Add OneDrive/SharePoint >> Create file >> name like export_${utcNow('yyyyMMdd')}.csv >> File content = output of Create CSV table.
v-achippaCommunity Support
Hi nandic ,
Thank you for reaching out to Microsoft Fabric Community.
Thank you rohit1991 for the prompt response.
As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.
Thanks and regards,
Anjan Kumar Chippa
- nandic
Hi everyone,
Thank you for replies and apologies for late answer.
As rohit1991 mentioned, i was searching for that option, to set ";" as delimiter, but i couldn't find it. After some research, ChatGPT confirmed there is no such option yet.
3. Add Data Operations >> Create CSV table >> Columns: Custom (map Country/City/Street) >> Delimiter: Semicolon (;).
I tested a few steps, finally, i've built Power Automate which works as expected.
It would be much easier if there was option to choose delimiter, however, at this point of time, there isn't such option on Power BI or Power Automate.
If anyone interested, here is my solution: https://data-trekking.com/2025/08/27/export-power-bi-data-with-semicolon-using-power-automate/