Forum Discussion
Matrix Visual - Change Export to CSV Delimiter
- 5 years ago
Hi Anonymous ,
You can vote on below ideas. If there are a lot of votes, the official Microsoft team will add this feature in subsequent version updates. Hope to help you.
Microsoft Idea · Export to CSV: regional settings support (powerbi.com)Microsoft Idea · Ability to choose delimiter when exporting to CSV (powerbi.com)
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Yes, I know that.
But I wanted the file to be automatically opened as an excel spreadsheet, and in order to do that, the CSV delimiter must be the same as the list separator in regional settings.
- Fowmy5 years ago
Super User
Anonymous
I hope you have set your delimiter to ; in the List Separator under the regional setting. Power Bi does not have an option to choose a delimiter for CSV export. You add this as an idea or vote for one if it is already there :- Anonymous5 years agoNot applicable
Yes, I have the semicolon as the List Separator under the regional settings, but Power BI uses the comma as the delimiter in CSV files.
- Fowmy5 years ago
Super User
Anonymous
Creating an idea on this request is really worth: https://ideas.powerbi.com/ideas/