Power Automate: Export To File for Power BI Reports with multiple report level filters

[AxelG137]

Hi,

I am currently working on Power Automate flows with the Export To File for Power BI Reports function. I noticed that at present only one report level filter is supported.

Are there plans to expand the function to multiple report level filters and if so, when?

Thank you

Axel

[v-lgarikapat]

Hi @AxelG137 ,

Thanks for reaching out to the Microsoft fabric community forum.

@Poojara_D12 , @BhavinVyas3003 

Thanks for your prompt response

@AxelG137 ,

For multiple report level filters with the Export To File for Power BI Reports function in Power Automate. Currently, it only supports one report level filter, but there’s a workaround you can try using URL filters. By constructing a filter string in the report’s URL, you can pass multiple filters dynamically before exporting. Simply add filter parameters directly to the report’s URL using filter queries, format each filter like &filter=Table/Column eq 'Value', and chain multiple filters together using and. For example, you can structure a URL like this:

https://app.powerbi.com/groups/{groupId}/reports/{reportId}?filter=Sales/Region

 eq 'West'&filter=Sales/Category eq 'Electronics'. This approach allows multiple filters to be applied without hitting the one filter limitation in

If multiple filters are applied directly on the report, exporting is currently not supported.
I recommend submitting this scenario as a feature request on the official Ideas forum.
The Product Team actively reviews suggestions there, and if others in the community upvote it, it may be considered for future updates.

Power Automate Ideas · Community

We appreciate your engagement and thank you for being an active part of the community.

Best Regards,

Lakshmi Narayana

[v-lgarikapat]

Hi @AxelG137 ,

I wanted to follow up and confirm whether you’ve had a chance to review the information we provided.
If you have any questions or need further clarification, please don’t hesitate to reach out.

Additionally, have you had a chance to raise this in the Ideas Forum regarding the issue?

If you’re still experiencing any challenges, we’d be happy to assist you further

Best Regards,

Lakshmi Narayana

[AxelG137]

Thanks for the provided insights.

I created the topic as a new idea in the Ideas Forum. Feel free to upvote it 👍

For my current problem I´m going to look further into the Paginated Reports since the other provided workarounds will prove difficult.

[Poojara_D12]

Hi @AxelG137 

You're correct that the "Export to File for Power BI Reports" action in Power Automate currently supports only a single report-level filter per export operation. This limitation can be restrictive when you need to apply multiple filters dynamically for report personalization or batch generation. While Microsoft has acknowledged this limitation, there is currently no official public timeline for expanding the functionality to support multiple report-level filters directly in a single API call. However, a common workaround is to combine multiple filtering conditions into a single complex DAX filter expression using logical operators (like and/or) within the supported filter structure. Alternatively, you can loop through multiple combinations using Power Automate's Apply to Each logic and export reports with different filters one at a time. For the latest updates, it's recommended to follow the Microsoft Power BI REST API documentation and the Power BI Ideas portal, where feature requests can be tracked and voted on by the community. Microsoft often prioritizes enhancements based on community feedback and demand, so raising visibility there may help expedite broader filter support in future API versions.

[BhavinVyas3003 · Accepted solution]

There is no update in the Microsoft Power BI documentation or on the Power Platform release plans about expanding support for multiple report-level filters.

Workarounds:

1. Use page-level or visual-level filters instead of report-level ones.
2. Create report bookmarks with pre-applied filters and trigger export using those.
3. Use Row-Level Security (RLS) to dynamically filter based on user or parameter.
4. For more complex use cases, consider Paginated Reports, which allow multiple filter parameters via URLs.