How to Export Specific Visuals with Bookmarks to PDF in Power BI via Power Automate

[Anonymous]

Hi Community, 

I'm currently facing a challenge with exporting a Power BI report to PDF. My goal is to export only certain visuals from a report page. Initially, I attempted to use the 'Pages Visual Name -1' option, specifying the visual IDs I wanted to export. However, this resulted in exporting only one visual per page, which is not what I require, as I need to export multiple specific visuals from a single page(if you could help me how to write query for multiple visuals that would be great.)

To address this, I created two bookmarks within my published report:

1. A 'Hidden' bookmark to display only the visuals needed for the export.
2. An 'All Visuals' bookmark showing every visual on the page.


When using the 'Export to File for Power BI Reports' connector in Power Automate, I encountered a field for 'Bookmark Name.' I input the GUID of my bookmark there but am unsure how to reference the bookmark name correctly to ensure the PDF export reflects the specific visuals defined by the 'Hidden' bookmark.

Additionally, there's an option for 'Bookmark State,' and I'm uncertain about its utilization and whether it could help in my scenario.

I would greatly appreciate any guidance on how to correctly use bookmarks for exporting specific visuals in a PDF and any insight on the 'Bookmark State' functionality.

Thank you in advance for your help!

[v-kaiyue-msft]

Hi @Anonymous ,

When you use the File Export to Power BI Report connector in Power Automate and encounter the Bookmark Name field, you should enter the name of the bookmark, not the GUID. The name should be exactly the same as the name you defined in Power BI (case-sensitive). The "Bookmark Status" option allows you to export the report in the current status defined by the bookmark. This link may help you: Solved: Export To File for Power BI Reports with multiple ... - Power Platform Community (microsoft.com). For more information about parameters, please refer to the documentation: Power BI - Connectors | Microsoft Learn.

If your Current Period does not refer to this, please clarify in a follow-up reply.

Best Regards,

Clara Gong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.