Export Power Bi report

(0) Share

Report

Posted on by Denise M

Hi community,

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/Mes eq 7), 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

Any help is appreciated. Thank you!

Categories:

Building flows

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

Sunil Kumar Pashikanti 1,286 Moderator on at

Like (0)

Report
Copy link

Link copied!

Hi @Denise M,

This is a Power BI limitation.
During export, slicer state always overrides filters passed via Power Automate, even if the filter arrives correctly. Synchronized slicers are applied before the Export API filters.

There’s currently no supported way to override slicer state during export. Your workaround using two export actions is the correct approach.
Power Automate also has no free built‑in way to merge PDFs/PPTX files, that requires premium connectors or an external solution.

For reliable automated exports, use a dedicated "Reporting Page" in your Power BI file that has zero slicers and relies entirely on the filters sent by your flow.

✅ If this answer helped resolve your issue, please mark it as Accepted so it can help others with the same problem.
👍 Feel free to Like the post if you found it useful.

Was this reply helpful? Yes No
MS.Ragavendar 6,245 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

@Denise M,

Power Automate doesn’t apply your filters unless you pass them explicitly. In the Export To File action, go to advanced options and set your filters under ReportLevelFilters using JSON. Make sure the field names match exactly.

Or, save a bookmark with the filters applied in Power BI and use the bookmark ID in the flow.

https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-url-filters#special-characters-in-url-filters

✅If this helped, please Accept as Solution to help others ❤️ A Like is appreciated 🏷️ Tag @MS.Ragavendar for follow-ups.

Was this reply helpful? Yes No