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.
Super UserHi Anonymous
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.