Dataflow Refresh in Power Automate

[BenFox]

I'm trying to setup a flow to refresh a Power BI dataflow. I saw back in December that there was a preview for just such a thing however I cannot find any info on if it's released or how to add it:

https://powerbi.microsoft.com/en-us/blog/announcing-dataflows-power-automate-connector-public-previe...

Is there any news on the connector?

I'm on the government power bi if that makes any difference. 

[will_cisler]

FYI to the community that there is a 'Refresh a dataflow' step now but it is not listed under Power BI.

[selimovd]

Hey @BenFox ,

that's still possible in Power Automate. Just add a Power BI element and you will see it.

Here I did it as a demo. Had to pixel the workspace list as there was sensitive data, sorry for that:

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[Anonymous]

how to wait or hold the second dataset or flow until first one is completed.

scenarios is there are 2 datasets in the flows

2nd one should start after 1st dataser refresh is completed

suggestion would be appreciated thanks

[BenFox]

I think that only works for datasets, not dataflows...

[selimovd · Accepted solution]

Hey @BenFox ,

sorry that was my mistake, I didn't read the question properly 😉

A data flow you can't refresh directly as an option, but you can refresh it with the API call.

For that you have to call the following REST API:

Dataflows - Refresh Dataflow - REST API (Power BI Power BI REST APIs) | Microsoft Docs

This is also possible in Power Automate:

Chris Webb's BI Blog: Calling The Power BI Export API From Power Automate, Part 1: Creating A Custom...

If you need any help please let me know.

If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍

Best regards

Denis

Blog: WhatTheFact.bi

Follow me: twitter.com/DenSelimovic

[jeffshieldsdev]

I've used them for dataflows. You don't see the actions and triggers when you search "dataflow"? Maybe it's disabled in your tenet?