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]