Make calculated table dynamic with Power Automate

Thankyou, Kedar_Pande and DataNinja777 for your responses.

Hi Zarina_H,

We appreciate your enquiry through the Microsoft Fabric Community Forum.

Based on my understanding, calculated tables in Power BI are static and are evaluated only during model processing. They do not respond to slicers or user interactions. With a live SSAS connection, model changes such as recalculated tables are not supported, only measures can be dynamic.

Please consider the following approach, which may help resolve the issue:

1. Since Power Automate cannot dynamically pass slicer values or refresh DAX calculated tables in a live SSAS model, as suggested by Kedar_Pande  and DataNinja777 , use DAX measures instead of calculated tables for the Sankey Amount logic. Measures are evaluated in the current filter context and therefore update immediately with Date slicer selections. If your model is in SSAS, request the model owner to add the same measure in SSAS or, if permitted, create a report level measure in Power BI Desktop.

Power Automate can be used for scheduled refreshes, dataset processing, or executing REST/XMLA API calls, but not for interactive slicer based recalculations. Use of the XMLA/REST API requires Power BI Premium or Power BI Premium Per User (PPU), and use of Power Automate with premium connectors requires a Power Automate Premium licence.

We hope the information provided helps to resolve the issue. Should you have any further queries, please feel free to contact the Microsoft Fabric Community.

Thank you.