export to csv comma separated

[jvandyck]

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?

[edved81]

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.

[krisztb]

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]

Thanks for the suggestion...will check