Refresh dataset after multiple dataflows complete parallel refresh

[mbbozzuto]

Hi - I have a single dataset that is populated from multiple dataflows.  I would like to create a Power Automate flow that will trigger the refresh of all dataflows in parallel after receiving an HTTP request call from an external orchestration service.  After the last dataflow completes refresh, then the dataset refresh will need to be triggered.  Here is a summary of the sequence:

1. HTTP request to trigger Power Automate flow

2. Multiple data flows triggered to initiate their refreshes (all running in parallel)

3. After the last of the data flow refreshes is complete, then trigger refresh of single dataset

The source of data for the data flows is not constrained and can be run in parallel.

Is this process flow achievable in Power BI service with Power Automate or other way?

[v-jayw-msft · Accepted solution]

Hi @mbbozzuto ,

Please take a look at this blog about data refresh API.

https://powerbi.microsoft.com/en-my/blog/announcing-data-refresh-apis-in-the-power-bi-service/ .

Best Regards,

Jay

[mbbozzuto]

@v-jayw-msft yes, this is the answer.