Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount.
Register nowThe Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.
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.
Solved! Go to Solution.
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:
End Result:
@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?
Hi,
I have same problem described in this topic.
Someone has any solution? Maybe PC definitions edditing?
delimiter of csv is usually preset in system regional settings - Region - Additional settings - Numbers - list separator
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:
End Result:
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
If you love stickers, then you will definitely want to check out our Community Sticker Challenge!
User | Count |
---|---|
49 | |
28 | |
21 | |
20 | |
20 |
User | Count |
---|---|
52 | |
51 | |
27 | |
26 | |
22 |