Export Python Visualization Table in CSV

[tegar-budi]

Hello,

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.

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.

Is it possible to do that?
Export visualization of python tables as users see them in the dashboard (summarized data) not the underlying data.

any assistance will be appreciated. thanks.

[V-lianl-msft]

Hi @tegar-budi ,

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 correct

https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-export-data#limitations-and... 

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

[tegar-budi]

I have this in Power BI dataset

Visual 1:

NIK  ||  Prev_score || Curr_score || Movement_Score

AAB ||    1              ||  1               ||  11

AAC ||    1              ||  2               ||  12

AAD ||    3              ||  1               ||  31

AAF ||    1              ||  2               ||  12

ABB ||    3              ||  1               ||  31

I Create python scripting for visual like this. for the users see in the dashboard

Visual 2:

     ||   1    ||   2   ||   3

1   ||   1    ||   2   ||   0

2   ||   0    ||   0   ||   0

3   ||   2    ||   0   ||   0

I 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 allowed

Any idea what should I do

Thanks.

[V-lianl-msft]

Hi @tegar-budi ,

Unfortunately, design makes.

You can try to pin the matrix to a tile-> print the tile.

See if this matches the output you expect.

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

[tegar-budi]

When I print the tile the file will be a paper or the file will be a PDF

But I need a export as spreadsheet format

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.

Thanks for helping

[V-lianl-msft]

Hi @tegar-budi ,

Unfortunately, power Bi does not support this feature yet.

I would suggest you to submit your idea to help improve power bi.

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