Export Data From Table On Desktop

[Anonymous]

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?

 

[Anonymous]

Still same, There is notable, and old (.pbix) files give the same type output.

[mahoneypat]

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

[Anonymous]

Happened to me after I changed options.

[Anonymous]

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 Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@ , Open a new excel and import data as csv and try