Forum Discussion
Using Power Automate to Update Filter Selection in Power BI Report
- 1 year ago
Hello PatrickGreen
Power Automate cannot directly modify Power BI report filters (like slicers or visual-level filters) through its standard actions. However, you can indirectly influence filters by updating the underlying data sources or using DAX queries.
Power Automate lacks actions to programmatically adjust Power BI report filters (e.g., slicers, dropdowns).
• Attempts to pass filters dynamically (e.g., via JSON) often fail due to syntax or authentication limitationsUse a parameter table (e.g., `FilterConfig` in SharePoint/SQL) to toggle filter logic in Power BI via DAX measures. Power Automate can update this table to trigger filter changes
- 1 year ago
Hi PatrickGreen
As highlighted by nilendraFabric, the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.
Hi PatrickGreen
As highlighted by nilendraFabric, the proposed approach appears to effectively address your requirements. Could you please confirm if your issue has been resolved
If you are still facing any challenges, kindly provide further details, and we will be happy to assist you.
If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.