Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
BenFox
New Member

Dataflow Refresh in Power Automate

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. 

1 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
 

View solution in original post

6 REPLIES 6
will_cisler
New Member

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

 

will_cisler_1-1696854540377.png

 

selimovd
Super User
Super User

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:

RefreshDataset.gif

 

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
 
Anonymous
Not applicable

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

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

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
 

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?

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.