cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kamakay Frequent Visitor
Frequent Visitor

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

6 REPLIES 6
ankitpatira Super Contributor
Super Contributor

Re: Export Csv with locale settings

@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

 

Capture.PNG

 

Moderator v-qiuyu-msft
Moderator

Re: Export Csv with locale settings

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

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
kamakay Frequent Visitor
Frequent Visitor

Re: Export Csv with locale settings

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 Frequent Visitor
Frequent Visitor

Re: Export Csv with locale settings

 I had the same your problem , I solved by removing, in the data editor, the comma as thousands separator (it was an obvious mistake)

kBogey Visitor
Visitor

Re: Export Csv with locale settings

I also have this problem.

What do you mean with "in the data editor" ?

Is this a setting within Power Bi, Excel, Windows, ... ?

If this is a setting within Power Bi, can you tell me where this setting is located ?

 

 

fabiocesarei Frequent Visitor
Frequent Visitor

Re: Export Csv with locale settings

Hi,

you must go to "Modeling" and to select your field from the fields frame. You'll find "Data type","Format", etc

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors