Export Python Visualization Table in CSV

Question

Hello,&nbsp;I want to export my python visualizaton table to excel or csv. one of the two. I can export tables. but the problem is the CSV results are not what I want.&nbsp;CSV from export provides data before the process or in other words the Power Bi give me the underlying data.but I want to export the data that users see in the dashboard. summarized data.&nbsp;Is it possible to do that?Export visualization of python tables as users see them in the dashboard (summarized data) not the underlying data.&nbsp;any assistance will be appreciated. thanks.

v-lianl-msft · Answer

Hi tegar-budi ,&nbsp;After my testing, I can export the summary data on the python visualization.You can refer to this document to check that your options are correcthttps://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and-considerations&nbsp;&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tegar-budi · Answer

I have this in Power BI datasetVisual 1:NIK&nbsp; ||&nbsp; Prev_score || Curr_score || Movement_ScoreAAB ||&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; 11AAC ||&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; 12AAD ||&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; 31AAF ||&nbsp; &nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; 2&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; 12ABB ||&nbsp; &nbsp; 3&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ||&nbsp; 1&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;||&nbsp; 31&nbsp;&nbsp;I Create python scripting for visual like this. for the users see in the dashboardVisual 2:&nbsp; &nbsp; &nbsp;||&nbsp; &nbsp;1&nbsp; &nbsp; ||&nbsp; &nbsp;2&nbsp; &nbsp;||&nbsp; &nbsp;31&nbsp; &nbsp;||&nbsp; &nbsp;1&nbsp; &nbsp; ||&nbsp; &nbsp;2&nbsp; &nbsp;||&nbsp; &nbsp;02&nbsp; &nbsp;||&nbsp; &nbsp;0&nbsp; &nbsp; ||&nbsp; &nbsp;0&nbsp; &nbsp;||&nbsp; &nbsp;03&nbsp; &nbsp;||&nbsp; &nbsp;2&nbsp; &nbsp; ||&nbsp; &nbsp;0&nbsp; &nbsp;||&nbsp; &nbsp;0I want my result export file look like Visual 2, but what I get is like Visual 1.I Already check your link and my data does not exceed the maximum limit of data allowedAny idea what should I do&nbsp;Thanks.

v-lianl-msft · Answer

Hi tegar-budi ,&nbsp;Unfortunately, design makes.You can try to pin the matrix to a tile-&gt; print the tile.See if this matches the output you expect.&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

tegar-budi · Answer

When I print the tile the file will be a paper or the file will be a PDF&nbsp;But I need a export as spreadsheet format&nbsp;I haven't found a way to export the way I want through Power BI.But I have found another solution. I export the file directly via python script.But I hope that this solution can be found so exporting will be easier for my users.&nbsp;&nbsp;Thanks for helping

v-lianl-msft · Answer

Hi tegar-budi ,&nbsp;Unfortunately, power Bi does not support this feature yet.I would suggest you to submit your idea to help improve power bi.&nbsp;Best Regards,LiangIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Export Python Visualization Table in CSV

5 Replies

Related content

export from visual table

Deneb visual exports blank to PowerPoint while standard Power BI visual exports correctly

Export data from visual

Power BI Export All Visuals - python notebook

Python Visuals Disabled Recently