Forum Discussion
Power Automate: Export To File for Power BI Reports with multiple report level filters
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:
- Use page-level or visual-level filters instead of report-level ones.
- Create report bookmarks with pre-applied filters and trigger export using those.
- Use Row-Level Security (RLS) to dynamically filter based on user or parameter.
- For more complex use cases, consider Paginated Reports, which allow multiple filter parameters via URLs.
Hi Anonymous ,
Thanks for reaching out to the Microsoft fabric community forum.
Thanks for your prompt response
Anonymous ,
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
Hi Anonymous ,
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
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.
Hi Lakshmi, v-lgarikapat
could you please explain this more in details?
I don't see an option to input the URL with filters in Power Automate?
Thanks and best.Luca
