Power Automate Export To File multiple bookmarks

[wynhodgkiss]

Hi,

Not sure if the PA forum or this one will hold the answer but I'll try here first. What I want to achieve is a flow that exports a single page of a report but with each bookmark on the page as a tab in ppt.

My flow so far works perfectly for a single bookmark, but I can't seem to add multiple bookmarks from the same page. Adding the same page twice brings an error and adding a 2nd bookmark to the bookmark array brings the same error.

This is the part of the flow that works:

[Anonymous]

Hi @wynhodgkiss ,

Unfortunately, this is not possible with the current Export to File for Power BI Reports action in Power Automate. This action only allows you to export one bookmark per page, and you cannot specify multiple bookmarks for the same page in the bookmark array.

Some possible workarounds for your scenario are:

- Create multiple copies of the same page in your Power BI report, each with a different bookmark applied. Then, use the Export to File for Power BI Reports action with the page array parameter to export each page as a slide in PowerPoint. This will result in a larger Power BI file size and more maintenance effort, but it will achieve the desired output.
- Use the Power BI REST API to export your report to PowerPoint programmatically. You can use the Export To File In Group API method with the bookmarkName parameter to specify a bookmark for each page. You can then use the Get Export To File Status In Group API method to check the status of the export and download the file when it is ready. You can call these API methods from Power Automate using the HTTP action or from any other platform that supports HTTP requests.

For more information, see these articles:

Export entire reports to PowerPoint - Power BI | Microsoft Learn

Export To File for Power BI Reports with multiple ... - Power Platform Community (microsoft.com)

Power BI Export to Power Point: Things You Need to Know - RADACAD

Best Regards,

Neeko Tang

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

[wynhodgkiss]

Thanks for your response. If I build this report a different way and use a slicer to control the views of the single page I want to export, is there any way to export a single ppt with multiple pages reflecting all the slicer options?

Also, I've got a total of 42 views to create and export in one ppt doc....is that even possible with either option or is there a limit?

[Anonymous]

Hi @wynhodgkiss ,

I understand that you want to export a single PowerPoint file with multiple slides that reflect all the slicer options of your Power BI report. Unfortunately, I don't think there is a native way to do this in Power BI or Power Automate. As far as I know, the export to PowerPoint option only exports the current state of the report, and you would have to manually change the slicer values and export each time.

Best Regards,

Neeko Tang

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