Forum Discussion
Helper IIIHandling Duplicate Page+Visual Pairs Error in Power Automate Flow
I created a Power Automate flow which sends Power BI reports via email.
A user requested a separate slide for each of the two slicer values on one of the pages.
To do this, I created two bookmarks, each for one value.
However, when trying to include these bookmarks in the Power Automate flow, I received an error: 'Export_To_File_for_Power_BI_Reports' failed. The error message said that exporting a report with duplicate page+visual pairs isn't supported.
Does this mean I can't use the same report page multiple times with a different bookmark name?
One solution could be to create a duplicate page, change the slicer value, and use that instead.
But if there are many slicer values, this could become complicated. Does anyone have advice on how to manage this?
Instead of bookmarks, use a measure that changes based on the slicer selection to display the relevant data on a single page.
Consider using Power BI Paginated Reports, which can handle multiple layouts more effectively.
Create separate reports for different slicer values and send them via Power Automate.
1 Reply
- Kedar_Pande
Super User
Instead of bookmarks, use a measure that changes based on the slicer selection to display the relevant data on a single page.
Consider using Power BI Paginated Reports, which can handle multiple layouts more effectively.
Create separate reports for different slicer values and send them via Power Automate.