Refresing Dataflows with Power Automate

[egomezcaro]

Hi there!

I am working with multiple dataflows that shall be refreshed in a "waterfall" type.

Dataflow 1 consists of Dimension Tables

Dataflow 2 & 3 consists of Dimension and Fact Tables

This should be easy using Power Automate and its new refreshing dataflows feature as following:

Dataflow 1 (end refresh) ---> (start refresh) Dataflow 2 (end refresh) ---> (start refresh) Dataflow 3

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.

Any idea of how to refresh fact tables?

Thanks!!

[v-yalanwu-msft]

Hi, @egomezcaro ;

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...

Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.