Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
when exporting data from table in PB, all the data is pushed to single column.
Is there any way to export data to seperated columns like the original table in PB?
What program are you trying to export to? In my experience, the csv output file is automatically separated by column when exporting to excel. Alternatively, you can manually set a delimiter as the commas separating the output data fields in your program of choice.
I'm unable to replicate this issue on my machine.. having no problems with the data being separated regardless of how I export. Have you tried checking the regional setting for list separator?
Control Panel > Region/Language options > Additional settings > List seperator set to comma.
Windows 7
Windows 8/10
To change regional settings,
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
14 | |
6 | |
4 | |
3 | |
3 |
User | Count |
---|---|
14 | |
9 | |
6 | |
3 | |
3 |