Matrix Visual - Change Export to CSV Delimiter

[rmcpdias]

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

[v-henryk-mstf · Accepted solution]

Hi @rmcpdias ,

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.

[rmcpdias]

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.

[Fowmy]

@rmcpdias 

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 : 

https://ideas.powerbi.com/ideas/

[rmcpdias]

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.

[Fowmy]

@rmcpdias 

Creating an idea on this request is really worth: https://ideas.powerbi.com/ideas/

[parry2k]

@rmcpdias 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.⚡