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 (49)
RE: Export to CSV: regional settings support
I have a built-in column separator for medium and then export to CSV is with a comma
RE: Export to CSV: regional settings support
When this is added - export to CSV with a semicolon
RE: Export to CSV: regional settings support
I found a workaround and thought I could share it here:Open the report online (app.powerbi.com).Click on the ... top right corner of the visualisation you want to have in Excel.Click on export dataNow you get a new screen that you don't get on the desktop power BI:And this gives you the .xlsx you need!
RE: Export to CSV: regional settings support
For the love of god, please, make it happen to export with semicolon. The majority of this world is using comma to show decimals!!!!
RE: Export to CSV: regional settings support
It should be a basic feature to export data with a regional setting. We have real issues with that missing.
RE: Export to CSV: regional settings support
Should be a basic feature to be provided, can not understand how Micfrosoft dioes not offer it.
RE: Export to CSV: regional settings support
In the Netherlands a ";" is used as a delimiter, because a "," is used for decimals and a "." for thousands.
RE: Export to CSV: regional settings support
Very important for the 'small' amount of non-USA-users around the world? :)
RE: Export to CSV: regional settings support
very basic feature missing since a while
RE: Export to CSV: regional settings support
We are trying to automate several internal reports and use PowerBI generated data to help source data for other analysis for different teams. This requires us to export the data for different customers. The data often includes full memo text, which is not easily delimited. We need option to set a custom delimiter so we can get the data out.