Forum Discussion
Export to excel automatically
I am using power bi report server (on premise). I need to download power bi report (mostly single table in each report) to be downloaded automatically? can anyone have any suggestion?
We dont have power automate
Hi learner_23 ,
The Power BI Reporting Server is built on SSRS, so you can take advantage of the SSRS subscription feature to schedule and automatically export reports. Although exporting directly to Excel may not be simple for Power BI reports, paged reports can be used for this purpose. Paginated reports are designed to be printed or shared, and they support scheduled delivery, including export to Excel. you can create a paged report that pulls data from the same dataset as the Power BI report.
The final output is shown in the following figure:
Below is the official link will help you:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
1 Reply
Hi learner_23 ,
The Power BI Reporting Server is built on SSRS, so you can take advantage of the SSRS subscription feature to schedule and automatically export reports. Although exporting directly to Excel may not be simple for Power BI reports, paged reports can be used for this purpose. Paginated reports are designed to be printed or shared, and they support scheduled delivery, including export to Excel. you can create a paged report that pulls data from the same dataset as the Power BI report.
The final output is shown in the following figure:
Below is the official link will help you:
Best Regards,
Xianda Tang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.