Forum Discussion
Need Help: Export Multiple Tables to One Excel File in Power BI Report Server
Hi Power BI Community,
I'm working on a Power BI Report Server project that includes multiple tables spread across 7 pages. I need to implement a solution where users can click a button (or use an extension) to download all these tables into one Excel file, with each table on a separate sheet.
I'm particularly interested in solutions or extensions that have premium support. If anyone has experience with this or can point me in the right direction, I'd greatly appreciate it!
Thanks in advance for your help.
Best regards,
3 Replies
Hi Lazurens ,
Regarding your question, there may not be a way to export all the data directly to Excel. You can export the data behind a single visual to Excel.Perhaps you can use Report Builder to generate a paginated report, which supports importing the entire report's data into Excel.
Create a paginated report for Power BI Report Server - Power BI | Microsoft Learn
Best Regards,
Wenbin ZhouThank you for your thought, if there is a way to use VBA, the export will be possible.
This is frustrating !
Hi, did you find a solution?
