Today I want to show you how to implement an auto dataset refresh after a dataflow is refreshed. On order to this, we use Power Automate.

Let’s say that after an Iowa_Liquor_Sales dataflow is refreshed we want to refresh an Iowa_Liquor_Sales dataset automatically.

So, create a New flow and choose an Automated cloud flow option.

Choose a When dataflow refresh completes trigger.

After creating the trigger, you are allowed to add steps to a flow.

For a trigger step, pick a workspace as a group type, a designated workspace and a dataflow from lists.

Add a Condition step, pick a Refresh status from available fields with a condition: “is equal to” “Success”. Like bellow.

Within an If yes section, add an Refresh a dataset action.

Choose a workspace and a dataset.

Once you save the trigger. It is automatically invoked always when the dataflow is refreshed with a “Success” status.

You can check a run history as well as the flow details.

One thing worth mentioning. Sometimes a trigger isn’t invoked immediately after a dataflow is refreshed.

As you see on the following screen. Time span is 14 min in this case.

This blog is part of Power Platform Week.

About the Author

Azure | Power BI Engineer

Molka, M., 2022, Power BI , Power Automate— auto refresh dataset after dataflow, Available at: Power BI , Power Automate— auto refresh dataset after dataflow | by Michal Molka | Medium [Accessed on 19 January 2023]