Using Power Automate to Update Filter Selection in Power BI Report

[PatrickGreen]

Hi! So I want to create a Power Automate button in a Power BI report, when upon clicking that particular button, it would update the date filter inside the report to contain last month. Has any work been done on this? I am trying to review the Power BI report actions possible in Power Automate, and I am not seeing yet if this could be possible.

[nilendraFabric · Accepted solution]

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 limitations

Use 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

[v-csrikanth · Accepted solution]

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.

[nilendraFabric · Accepted solution]

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 limitations

Use 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