add a button to export all visual data directly in power bi instead of clicking ... in all visuals

[Anonymous]

Hi Guys, 

how to a dd a button to export all visual data to CSV or Excel  directly in power bi instead of clicking ... in all visuals

[Anonymous · Accepted solution]

Hi @Anonymous ,

As Idrissshatila said, you can do what you want with Power Automate visual.

If what you want is to select data on all views at once and import it into Excel. This is not currently possible in Power BI, which only selects and returns a set of data from a view.

So if you want all the data, you can only create multiple buttons and export the data in batches.

Best Regards

Yilong Zhou

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

[Anonymous]

thank you @Idrissshatila  , I watched it , but he has used only one visual , but i need to have all visuals to be export into csv when user clicks on button 

[Idrissshatila]

@Anonymous , and you can't replicate what he did several times  ?

[Idrissshatila]

Hello @Anonymous ,

this can't be acheived with Power BI only, you need to use power automate to make this happen.

check this out
https://youtu.be/mHEfUYV4NQ4?si=cCvPEgcDuw-MyAbp