Forum Discussion
add a button to export all visual data directly in power bi instead of clicking ... in all visuals
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
- Anonymous2 years ago
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.
4 Replies
- Idrissshatila
Super User
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 - AnonymousNot applicable
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
Super User
Anonymous , and you can't replicate what he did several times ?
- AnonymousNot applicable
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.