Export Reports in report server

[AYAELYOUSS]

Hello Microsoft Community,

Is there any way to allow end users to export a PBIRS (On-Premise) dashboard to PDF/PPT/Excel directly from the published web link without redesigning the report as a Paginated Report and without requiring Power BI Desktop on the client Side? I want end users to open the published URL and export to PDF without any intermediate tools. Any workarounds or recommended approaches.

Thanks.

[v-tsaipranay · Accepted solution]

Hi @AYAELYOUSS ,

We haven’t received an update from you in some time. Could you please let us know if the issue has been resolved?
If you still require support, please let us know, we are happy to assist you.

Thank you.

[v-tsaipranay]

Hi @AYAELYOUSS ,

Thank you for explaining your requirement. I understand that you want the export process to be smooth for end users while keeping the PBIX layout and design unchanged.

At present, Power BI Report Server does not have a built-in option or API to automatically export Power BI reports (.PBIX) across multiple pages or with filters applied. The “Export to File” feature in Power BI Service is not available in PBIRS.

For the Selenium approach, the issue of capturing only the first page happens because PBIRS renders each report page in an iframe. To capture all pages, the script needs to switch between iframes, simulate navigation, and refresh visuals or filters for each page. This is possible with Selenium or Puppeteer, but it requires a custom automation setup and ongoing maintenance.

Alternatively, you could use Power Automate Desktop for UI automation or host the report in Power BI Service (Premium or Fabric), which allows direct export to PDF, PPTX, and Excel using the REST API and built-in export features.

Thank you.

[v-tsaipranay]

Hi @AYAELYOUSS ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions. 

Thank you.

[AYAELYOUSS]

Hi ,

Thank you very much for your detailed explanation.

Actually, my goal is to make the export process easier for end users — since they can’t press Ctrl + P each time to export page by page. They may also need other formats like Excel or PPT, so the first option is quite limited.

For the second approach (Selenium), could you please share a resource or example script?
I’ve already created one, but it only captured the Home page and didn’t take screenshots of all pages in the report. It seems that I would need to simulate navigation between report pages and also consider user-selected filters, which makes it a bit tricky.

As for the third option (RDL), it’s not suitable for our case because the Paginated Report (RDL) can’t reproduce the same design and visuals as the original PBIX — and we aim to keep exactly the same layout and user experience.

Thank you again for your support!

Best regards,
Aya

[v-tsaipranay]

Hi @AYAELYOUSS ,

Thanks for reaching out to the Microsoft fabric community forum.

Currently, Power BI Report Server (PBIRS) does not offer a built-in option for end users to export Power BI reports (.PBIX) directly to PDF, PPT, or Excel from the web portal; these export features are currently available only for Paginated Reports (.RDL). 

There are several alternative approaches you can consider. Users may print the report to PDF using the browser’s Print to PDF function (Ctrl + P -- Save as PDF) in Chrome or Edge, which is suitable for straightforward exports. 

Alternatively, you can embed PBIRS reports in a custom internal web page and utilize automation tools such as Puppeteer or Selenium to capture screenshots and export them as PDF or Excel files. 

Lastly, creating a simplified Paginated Report (RDL) focused on key tables or summaries can provide a clean export option, while maintaining the main PBIX for interactive use.

Please refer the following documentation for detail information : Reports - Export To File - REST API (Power BI Power BI REST APIs) | Microsoft Learn

Also Thank you @tayloramy  for replying to the query.

Thank you.

[tayloramy]

Hi @AYAELYOUSS,

For Power BI Report Server (PBIRS), end users can’t export an on-prem PBIX report to PDF/PPT/Excel directly from the web portal. That capability exists in Power BI Desktop (Export to PDF) and in the Power BI Service (Export to PDF/PPTX), but not for PBIX in PBIRS. If you need one-click export from the browser on PBIRS, the supported route is to publish a Paginated (RDL) report, which exposes an Export menu and also supports URL-based export and subscriptions. See details below.

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.