Adding a Download Button to Export All Visuals' Data as CSV

Hi Bhavyasree24 ,

If you have one visualization on the page, you can use the "Export data" functionality, which creates a table from each visualization and saves it to a file.

If you have more visualizations, unfortunately at the moment I don't know of any solution that would allow you to generate several csv files with a single mouse click. The problem here is also with interactions and filtering, because such a solution would also have to take into account the choice made by the end user and generate only the data that is currently available.

If you want to generate some specific data sets, you can predefine them as DAX code and then write a flow in Power Automate, which will generate csv files one by one and save/send them with a single button in Power BI.

Resident Rockstar | Former Super User If I helped, please accept the solution and give kudos!  Connect with me Linkedin

Hi,

Thanks for the solution lkalawski  offered, and i want to offer some more information for user to refet to.

hello Bhavyasree24 ,in power bi deskop, as lkalawski  mentioned, it cannot download all the data one time, you can only click one visual and select

.

you can consider to publish it to web, then use analyze in excel function, you can refer to the following link about it.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-analyze-in-excel#analyze-in-excel

If the solution lkalawski  and i offered help you solve the problem, you can consider to accept them as soluitoons so that more user can refer to.

Best Regards!

Yolo Zhu

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