cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
eddydm Member
Member

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

Accepted Solutions
alanhodgson Established Member
Established Member

Re: Export to csv: configuration

Hey @eddydm,

 

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
alanhodgson Established Member
Established Member

Re: Export to csv: configuration

Hey @eddydm,

 

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

eddydm Member
Member

Re: Export to csv: configuration

@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

Sasa Frequent Visitor
Frequent Visitor

Re: Export to csv: configuration

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?

kseniap Frequent Visitor
Frequent Visitor

Re: Export to csv: configuration

Hi,

I have same problem described in this topic.

Someone has any solution? Maybe PC definitions edditing?

HoKe Frequent Visitor
Frequent Visitor

Re: Export to csv: configuration

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

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors
Top Kudoed Authors