Forum Discussion

kamakay's avatar
kamakay
Regular Visitor
10 years ago

Export Csv with locale settings

Dear all

 

I would like to know if it is possible to export data from tiles/charts cnosidering the computer locale instead of the powerbi settings.

 

Let me explain, I am using powerbi with dicimal nubers with "." as decimal separator (english us) but our customers are Italian and would export the csv with "," s decimal separator.

 

Is this possible?

 

Many thanks in advance

Kama

Need Help

6 Replies

  • ankitpatira's avatar
    ankitpatira
    Icon for Community Champion rankCommunity Champion
    10 years ago

    kamakay there is locale option to specify regional settings but not sure if that would have any effect on export as it is under Data Load. My feeling is it is for import of data but you can try it out.

     

    Under File on top left hand corner -> Options and settings -> Options -> Under CURRENT FILE -> Data Load

     

     

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    10 years ago

    Hi Kama,

     

    In Power BI Service, it will not consider local computer region when exporting data from a visual. To set decimal separator as “,” for numbers, you need to change Language as Italiano in Settings page.

     

    If you have any question, please feel free to ask.

     

    Best Regards,
    Qiuyun Yu

    • kamakay's avatar
      kamakay
      Regular Visitor
      10 years ago

      Hi!

       

      I tried to change settings to Italian Language but I still export decimal nmbers with the english separator instead of the italian separator, the comma ",".

      What could be your suggestion?

       

      Thanks again

      Kama

      • fabiocesarei's avatar
        fabiocesarei
        Icon for Advocate I rankAdvocate I
        10 years ago
         I had the same your problem , I solved by removing, in the data editor, the comma as thousands separator (it was an obvious mistake)