I am facing some issues related to the Export Power BI Report to File activity in a Power Automate flow. The user has to select a month (Mes Nombre) and a file format (FormatoSeleccionado) using slicers, then press a button to initiate the flow. These slicers are synchronized across 4 pages and are hidden. There is one additional page that should not be filtered by month and therefore has no slicer.
The slicers work perfectly both in Power BI Desktop and Power BI Service. The problem I am facing is the following:
Although my flow receives the selected month correctly, and the pages are filtered correctly in Power BI Service, the exported file does not filter correctly. I confirmed this by checking the flow execution history — the filter value arrives correctly to the export activity (e.g. Calendario/MesNombre eq 'Febrero'), but the exported file always shows the month that was selected when I published the report.
I tried both pageLevelFilters and reportLevelFilters with the same result. Pages containing the synchronized slicer always export with the published state, while the page without the slicer shows all months (unfiltered), which confirms the slicer state is overriding the filter passed by the connector.
My current workaround is using 2 separate export activities: the first one with reportLevelFilters selecting only the 4 pages that should be filtered, and the second one with no filters for the exceptional page. This works correctly, but requires merging the output files afterwards. Unfortunately, I have no license for Adobe, Muhimbi or other premium connectors.
I am looking for either:
- A way to override the synchronized slicer state via the export connector without splitting into 2 activities, or
- A free or included method to merge PDF/PPTX files within Power Automate without premium connectors (possibly using Power Automate Desktop or Office Scripts)
Any help is appreciated. Thank you!
