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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Vikas10000
New Member

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

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.)

 

id's.png


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.

Bookmarks image.png
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.

bookmark image.png


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!

1 REPLY 1
v-kaiyue-msft
Community Support
Community Support

Hi @Vikas10000 ,

 

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..... 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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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