Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Win a FREE 3 Day Ticket to FabCon Vienna. Apply now

Reply
kylecuera
Regular Visitor

Power BI: Printing using Bookmarks Workaround

Hi All,

 

I would like to ask the community if you encountered this kind of problem and come up with an efficient solution.

 

Problem Statement: We have a dashboard that shows data and can be sliced per project. The client wants to store the slides every month in PDF. So I come up with a solution in Power Automate to print for every project. Now I utilize "bookmarks" to store the sliced report for every project and trigger Power Automate to print those bookmarks. I just sampled a few but our estimated projects in the future are about 400. So that means I have to create about 400 bookmarks and run the automation through it which I think could affect the load of the dashboard and the automation itself.

 

It would be highly appreciated if you know a workaround for this. Thank you!

 

1 REPLY 1
Poojara_D12
Super User
Super User

Hi @kylecuera, as  per me, your current approach using bookmarks to store filtered views of the dashboard and triggering Power Automate for PDF export is efficient for a small number of projects, but scaling it to 400 projects would be impractical. Managing such a large number of bookmarks would increase the complexity, affect performance, and make automation execution inefficient.

Alternative Solutions:

1. Use Power Automate with Power BI Export API (Recommended)

Instead of creating 400 bookmarks, dynamically filter the report for each project and export it using Power Automate's "Export Power BI Report to PDF" action.

  • Steps:

    1. Remove the bookmarks for individual projects.
    2. In Power Automate, use the "Export Report" action.
    3. Pass the Project Name or ID dynamically as a filter in the API request.
    4. Loop through the project list and generate PDFs dynamically.
  • Advantages:
    No need to manually create bookmarks.
    More scalable and efficient for 400+ projects.
    Reduces dashboard load and complexity.

 

2. Use Paginated Reports (If Available)

If your report is based on a Premium Capacity, you can use Paginated Reports in Power BI, which support dynamic filtering and exporting in bulk.

  • Steps:

    1. Create a paginated report with a parameter for Project Name/ID.
    2. Use Power Automate to loop through the projects and export PDFs dynamically.
  • Advantages:
    Designed for large-scale reporting.
    Supports high-quality PDF exports without bookmarks.

 

3. Power BI Service Scheduled Subscriptions (For Small-Scale Use)

If only a few key projects need to be exported, consider Power BI Email Subscriptions to automatically email filtered reports in PDF format.

  • Limitations:
    Doesn't scale well for 400 projects.
    Requires manual setup for each project.

Best Approach for You:

Since you're dealing with 400+ projects, the best approach is Power Automate with the Power BI Export API, where you dynamically filter and export reports without bookmarks. This will significantly improve performance and automation reliability while eliminating manual effort.

 

 

Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"

Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.