How to execute Power Automate at the successful completion of Azure data factory pipeline?

Question

I need to create and run Power Automate flow to refresh Power BI dataset at the successful completion of my Azure data factory pipeline.

Flow should not run if data pipeline fails. How could I do it?

Answer 1

You don't need a Power Automate flow to refresh the Power BI dataset, when ADF pipeline is successful. That can be done directly from ADF pipeline to Power BI dataset.

How To Trigger A Power BI Dataset Refresh Using An Azure Data Factory Web Activity

Answer 2

You can use Do Until after Create a pipeline run activity. Inside Do Until you will have to specify until what(condition) your loop should run. Here you have to check the if the Status of the pipeline is not equal to InProgress. Now the loop should have 2 flows, namely - get a pipeline run (to fetch the status) and delay timer of 10s to recheck the pipeline status in every 10s. After the do until loop, set a powerbi refresh and voila.