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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

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
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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