Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

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

Need Help

6 Replies

  • parry2k's avatar
    parry2k
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
    Anonymous
    Not applicable
    5 years ago

    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's avatar
      Fowmy
      Icon for Super User rankSuper User
      5 years ago

      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 : 

       

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

      • Anonymous's avatar
        Anonymous
        Not applicable
        5 years ago

        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.

  • v-henryk-mstf's avatar
    v-henryk-mstf
    Icon for Community Support rankCommunity Support
    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.