Export PDF with Selected Pages of Power BI

[ribisht]

Hi Power BI Experts. I have a problem where we may need a workaround. If I have a power BI Dashboard that has about 30 different pages and each page can be exported as a slide in a powerpoint presentation, is there a way where the use can choose the pages they want in the presentation for export? 

[lbendlin · Accepted solution]

Use Power Automate.  There you can specify the individual pages that should be included in the export.

[ribisht]

@all 

We have a report with 30 pages, but we only need to export 20. Is it possible to selectively export pages, and how does that affect performance? do we have any limit with Power BI Automate

[lbendlin]

You can do that with Power Automate. Keep in mind that every single selected page is re-rendered every single time. You need to make sure that the rendering does not time out (which would result in some pages being blank randomly).  Spend time and effort optimizing the report  visuals before attempting this.

[v-hjannapu]

Hi @ribisht,
Thanks for Followup,

Right now, Power BI doesn’t have a direct option to export selected pages to PowerPoint  it either exports all report pages or just the current one.

But there’s a good workaround using Power Automate. With that, you can choose exactly which pages like your 20 out of 30 you want to export. You just need to use the “Export to File for Power BI Reports” action in Power Automate.

A few things you may try:
     This works only if your report is published to Power BI Service not in Desktop.
     You will need Power BI Premium either per user or workspace.
     There’s a limit you can export up to 50 pages per report using this method.

About performance  exporting 20 pages should work fine unless your visuals are too heavy. It may take a few extra seconds.

Hope this helps if you have any queries we are  happy to assist you further.
Thank you.

[v-hjannapu]

Hi @ribisht,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

Regards,
Harshitha.

[v-hjannapu]

Hi @ribisht,
I hope the above details help you fix the issue. If you still have any questions or need more help, feel free to reach out. We are always here to support you.

Regards,
Harshitha.

[HarishKM]

@ribisht Hey,

Power BI does not natively support selective page exporting to PowerPoint presentations directly from the dashboard interface. However, you can implement a workaround to achieve this functionality using the following steps

1. • Manually manage the pages you wish to export from Power BI.
   • Export the bookmarked pages into a PDF first, which can be converted into slides.Export the desired pages individually using the "Export to PDF" feature, and then convert the PDF into PowerPoint slides.
   • Utilize bookmarks to capture specific views or pages of your dashboard. This feature allows you to quickly navigate to the pages you want to export.
   • Create separate reports catering to specific needs with selected pages only. This might involve duplicating the report and removing or hiding pages.

Thanks

Harish KM

If these steps help resolve your issue, your acknowledgment would be greatly appreciated.

[v-hjannapu · Accepted solution]

Hi @ribisht,
Thank you for posting your query in Microsoft Fabric Community Forum. 
Also, thanks to @lbendlin  , @MasonMA    for those inputs on this thread. 
 
In Power BI, there is no direct option to select and export only a few pages from a report into PowerPoint. You can either export the full report or just the current page one at a time.

here are some workarounds you can try:
Manual Way you can do go to each page you want → export it as PowerPoint current page only → then later combine all those slides into one PowerPoint file.

Power BI Add-in for PowerPoint If it’s allowed in your company, you can use this add-in to show live report pages inside PowerPoint. That way, users can interact with visuals in presentation itself.

Power Automate for advanced users If you are using Power BI Pro or Premium, you can set up a Power Automate flow where you can choose which pages to export automatically. It needs some setup though.

Kindly refer to the below documentation links for better understanding:
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-automate-power-bi-report-export
https://learn.microsoft.com/en-us/power-bi/collaborate-share/end-user-powerpoint
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-power-bi-powerpoint-add-in-inst...

Hope this helps if you have any queries we are  happy to assist you further.
Best Regards,
Harshitha.

[lbendlin · Accepted solution]

Use Power Automate.  There you can specify the individual pages that should be included in the export.

[ribisht]

Thanks for your Answer, 

We have a report with 30 pages, but we only need to export 20. Is it possible to selectively export pages, and how does that affect performance? do we have any limit with Power BI Automate?

[MasonMA]

HI @ribisht 

Power BI’s built-in Export to PowerPoint feature does not support selective page-level exports directly. When you export, all visible report pages are exported as static images and you can choose to export the current page only, but not a custom selection of multiple pages. 

Export entire reports to PowerPoint - Power BI | Microsoft Learn

Would you be able to use Power BI Add-in for PPT at your workplace? You can embed live report pages into PowerPoint using the Power BI add-in and users can interact with the report inside PowerPoint, which is great for dynamic presentations.