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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
Anonymous
Not applicable

Export to csv: configuration

Hello there,

 

 

Is there any possibility to configure the export to csv?

Each time we like to open the csv-file with Excel, we get one column with all the values concatenated.

We have to open a blank sheet in Excel, import the csv-file and tell excel to use a comma as separator, ...

 

Thanks in advance for any idea.

1 ACCEPTED SOLUTION
alanhodgson
Solution Supplier
Solution Supplier

Hey @Anonymous,

 

This can be done with a simple R script. You will need to have R installed and the package "utils".

See my screenshots below:

 

Script w/ visual:

Capture9.PNG

End Result:

Capture10.PNG

View solution in original post

5 REPLIES 5
Anonymous
Not applicable

@alanhodgson I'm not used to use R-scripting.

I have the impression that your solution has to be develloped for each export i want to do. Correct me if I'm wrong.

(So at this moment i don't think i got an answer. I don't know who has closed this issue by accepting the answer as a solution. I don't know how to reopen this issue.)

 

 

I would like to have the possibility that a user can tell to the system that he wants to use tabs instead of , as seperator (and other choices) and that this is working for each export for each visual in the whole report.

 

Thanks in advance for any information!

 

 

Eddy

Same here. On one PC it is exported as csv in separate columns.

On other PC it exports it all data in one column ( separated by coma).

Any solutions how to solve this problem ,so it exports data in separated columns?

Anonymous
Not applicable

Hi,

I have same problem described in this topic.

Someone has any solution? Maybe PC definitions edditing?

Anonymous
Not applicable

delimiter of csv is usually preset in system regional settings - Region - Additional settings - Numbers - list separator

alanhodgson
Solution Supplier
Solution Supplier

Hey @Anonymous,

 

This can be done with a simple R script. You will need to have R installed and the package "utils".

See my screenshots below:

 

Script w/ visual:

Capture9.PNG

End Result:

Capture10.PNG

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

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