Export data with semicolon (;) delimiter

[nandic]

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

[nandic · Accepted solution]

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/

[v-achippa]

Hi @nandic,

Thank you for the response and confirming that the issue is resolved. I request you to please mark your post as Accept as Solution so that other community members who has similar issue will find it more easily.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

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

[v-achippa]

Hi @nandic ,

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

[v-achippa]

Hi @nandic ,

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

[rohit1991]

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.