Forum Discussion

Frequent Visitor

2 years ago

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 a...

Need Help

Anonymous

Not applicable

2 years ago

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

Export a paginated report to Microsoft Excel (Report Builder) - Microsoft Report Builder & Power BI Report Builder | Microsoft Learn

Best Regards,
Wenbin Zhou