Forum Discussion
Resident RockstarExport data with semicolon (;) delimiter
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/
Super UserHi 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.