cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
jvandyck Regular Visitor
Regular Visitor

export to csv comma separated

If I want to export to CSV, it is comma separated per default, even though my regional settings are set to semicolumn.

Any idea how to change this?

3 REPLIES 3
Power BI Team krisztb
Power BI Team

Re: export to csv comma separated

Try to change the DeviceInfo settings for the CSV rendering extension:

Check FieldDelimiter field in the spec: https://docs.microsoft.com/en-us/sql/reporting-services/csv-device-information-settings

 

This page shows how rendering extensions can be tweaked in general: https://docs.microsoft.com/en-us/sql/reporting-services/customize-rendering-extension-parameters-in-...

jvandyck Regular Visitor
Regular Visitor

Re: export to csv comma separated

Thanks for the suggestion...will check

edved81 Frequent Visitor
Frequent Visitor

Re: export to csv comma separated

try this:

 

1º export to csv file, from powerbi report.

2º Open excel,

3º New file -> menu data-> from text/CSV (and select the csv file exported).

3º Select delimiter;

3º Load.