Refresing Dataflows with Power Automate

Question

Hi there!&nbsp;I am working with multiple dataflows that shall be refreshed in a "waterfall" type.&nbsp;Dataflow 1 consists of Dimension TablesDataflow 2 &amp; 3 consists of Dimension and Fact Tables&nbsp;This should be easy using Power Automate and its new refreshing dataflows feature as following:&nbsp;Dataflow 1 (end refresh) ---&gt; (start refresh) Dataflow 2 (end refresh) ---&gt; (start refresh) Dataflow 3&nbsp;BUT, because of the lineage of the dataflows, dimensions of DF2 and DF3 are dependant of DF1. Therefore, by refreshing DF1, automatically dimension tables of 2 and 3 are also refreshed, and the flow in power automate interprets DF2 and 3 are successfully refreshed and it STOPS. The fact tables of DF2 and consequently the fact tables of DF3 are not refreshed.&nbsp;Any idea of how to refresh fact tables?&nbsp;Thanks!!&nbsp;&nbsp;

v-yalanwu-msft · Answer

Hi,&nbsp;Anonymous&nbsp;;
Refer if these can help a bit.
https://community.powerbi.com/t5/Service/Dataflow-Refresh-in-Power-Automate/m-p/1920695
https://www.datapears.com/post/dataflows-power-automate-connector-fully-automate-your-data-refresh
https://powerusers.microsoft.com/t5/Power-Automate-Community-Blog/Custom-Connector-in-Power-Automate-Microsoft-Flow-for-Power-BI/ba-p/626110
&nbsp;
Best Regards,Community Support Team_ Yalan WuIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

Refresing Dataflows with Power Automate

1 Reply

Related content

Automating Dataflow Gen2 destination changes in deployment pipelines

dataflow gen1

Fabric Dataflow Gen 2

Dataflow Refresh in Power Automate

Automated refreshes