Skip to main content

Power BI

Needs Votes

Export to CSV: regional settings support

Vote (196) Share
Gianni Bergamo's profile image

Gianni Bergamo on 08 Sep 2016 23:21:24

Add the possibility to export to CSV with support for regional settings (decimal separator, column separator, etc.)

Comments (27)
Gianni Bergamo's profile image Profile Picture

74906214 7046-e911-a95d-000d3a4f36ce on 05 Jul 2020 23:09:33

RE: Export to CSV: regional settings support

This would certainly help many of our users. Has this been approved for a roadmap yet? Any input for when it might become available?

Gianni Bergamo's profile image Profile Picture

64bef5a1 5e9c-45f4-81ec-3371c0af01cf on 05 Jul 2020 23:09:03

RE: Export to CSV: regional settings support

This feature is very important or could be implemented a delimiter parameter.

Gianni Bergamo's profile image Profile Picture

9bb618be a50f-4f85-993b-ce2608655a43 on 05 Jul 2020 22:51:34

RE: Export to CSV: regional settings support

Or at least they could put the line sep= on top of the csv file as this post says:

sep=,
COLUMN1|COLUMN2
data,1|data2

https://superuser.com/questions/407082/easiest-way-to-open-csv-with-commas-in-excel

Gianni Bergamo's profile image Profile Picture

cf302a4d 4e0a-4c27-9691-5e7337a845d3 on 05 Jul 2020 22:35:58

RE: Export to CSV: regional settings support

Definitely a must have. Something so simple and yet it has a major impact on user experience in countries that do not use comma separated CSV-files.

Gianni Bergamo's profile image Profile Picture

79d17abe df03-4b0f-b8c5-6d940e2e04e3 on 05 Jul 2020 22:32:52

RE: Export to CSV: regional settings support

It would have been very useful today... had to do it manually.

Gianni Bergamo's profile image Profile Picture

d2985fe9 1dd2-4f30-91ae-4cf5dc3e2af6 on 05 Jul 2020 22:32:15

RE: Export to CSV: regional settings support

This should be expanded to simply allow for more export options in general, such as to xls format

Gianni Bergamo's profile image Profile Picture

7aba1668 22f5-4fe6-b19e-092e19c1c785 on 05 Jul 2020 22:30:02

RE: Export to CSV: regional settings support

Highly recommend! The current CSV export is unusable in our regional settings and therefore in a hindrance in getting PowerBI penetration for the whole enterprise.