Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
jvandyck
Helper IV
Helper IV

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

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
Power BI Team
Power BI Team

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-...

Thanks for the suggestion...will check

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors