We're giving away 30 tickets for FREE! Share your story, your vision, or your hustle and tell us why YOU deserve a ticket.
Apply nowWin a FREE 3 Day Ticket to FabCon Vienna. Apply now
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!
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.
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:
Advantages:
✅ No need to manually create bookmarks.
✅ More scalable and efficient for 400+ projects.
✅ Reduces dashboard load and complexity.
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:
Advantages:
✅ Designed for large-scale reporting.
✅ Supports high-quality PDF exports without bookmarks.
If only a few key projects need to be exported, consider Power BI Email Subscriptions to automatically email filtered reports in PDF format.
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.
User | Count |
---|---|
5 | |
2 | |
1 | |
1 | |
1 |
User | Count |
---|---|
6 | |
4 | |
3 | |
3 | |
2 |