Forum Discussion
Export Data From Table On Desktop
When I export data from the table, Exporting is not a table in .csv . It's coming like the picture. How can I fix that? Could you help me, please?
5 Replies
@ , Open a new excel and import data as csv and try
The data are unpivoted. To get the pivoted data from the matrix, there are at least two approaches.
1. Publish your report and view it in the Service. The export data option now allows you to export to Excel in the current format.
2. Use a paginated report connected to your published dataset and recreate your matrix there. You can then run and export your data in different formats.
Pat
Hi Anonymous ,
I have a test to export data from visual into CSV and open it by excel. It seems to work well in my side.
Please check the version of your desktop and your excel. You can update them to the latest version and try again.
As mahoneypat mentioned, if you want to export data into excel directly, you can publish your report to Power BI Service. You need to turn on this function in report setting and admin portal. Then you can export data from visual into excel and get data like a table directly.
Here is the offical blog, you may learn from them to get more details.
For reference:
Export the data that was used to create a visualization
Tutorial: export data from a visual to Excel
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
