Forum Discussion
Matrix Visual - Change Export to CSV Delimiter
Hi, good afternoon.
I have a matrix visual in one of my reports and I was wondering if it's possible to change the delimiter when exporting data to CSV? The defaul delimiter is a comma. I would like to use a semicolon.
Best Regards,
Rui
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.
6 Replies
Anonymous when you connect to csv, you can change the delimiter, screenshot below
✨ Follow us on LinkedIn
Check my latest blog post The Power of Using Calculation Groups with Inactive Relationships (Part 1) (perytus.com) I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!
⚡ Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
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 :
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.
