Refresh All Dataflows and Datasets With Power Automate

[snayff]

We have scheduled refreshes set up for our dataflows and datasets, but due to a regular outage of one of the sources we often need to manually retrigger all of the 'flows and 'sets, so I'd like to set up some automation that handles this. We can trigger a Power Automate flow on demand and there's a connector to allow refreshing a specified dataset, but I am not sure how to get the list of existing 'flows/'sets. We would also need to run the flows first, so I'd need to identify those and loop over them first. I suppose I could manually type out each 'set/'flows  details into a sharepoint list and pull from there, but dynamic is preferred. 

Any suggestions on what to look at or how to approach this would be appreciated!

[v-yiruan-msft · Accepted solution]

Hi @snayff,

Please review the following links, hope they can help you.

Trigger dataflows and Power BI datasets sequentially

HOW TO REFRESH MULTIPLE POWER BI DATASETS USING POWER AUTOMATE AND THE POWER BI API

Refresh All Datasets from Power BI Desktop with 1 Click

Refresh your Power BI dataset using Microsoft Flow

How to Refresh a Dataflow Using Power Automate 

Best Regards