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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
luis-martins
Helper I
Helper I

Refresh All Dataflow and after doing Refresh Dataset

Hello guys!

I have one doubt, I would like to know if it's possible and if yes how to Refresh all DataFlows and After this Dataflow as been completed Refresh the Dataset, this within a report in PowerBI.

My structure is:

- 5 Dataflows 

- 1 Dataset (contains 5 dataflows).

Thank you in advance

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @luis-martins ,

 

by default there is nothing like that.

You have to time it. So you can start the refresh of the dataflows at 8 in the morning. Let's guess the frefresh takes 10 minutes. Then you can plan the refresh of the dataset at 8:30.

 

You could also trigger the fresh in Power Automate or with the REST API. But there you have to think about a mechanism that is checking every minute if the refresh is finished and then start the refresh of the data set.

 

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

4 REPLIES 4
ajerovich
Advocate II
Advocate II

Not sure when it was added but there is now an action to refresh a dataflow, and a trigger to go based on when a dataflow complete refresh completes. So I've set up a power automate that sequentially refreshes dataflows, waits for them to finish refreshing, checks that they completed (not failed, if failed try again and send an error email) based on a spreadsheet that lists the workspace and dataflow IDs.

jeffshieldsdev
Solution Sage
Solution Sage

There are triggers in Power Automate for when dataflow refreshes finish. You can add these to your flow, refresh dataflow action, refresh dataflow complete trigger, refresh dataflow action, etc and then refresh the dataset afterwards.

selimovd
Super User
Super User

Hey @luis-martins ,

 

by default there is nothing like that.

You have to time it. So you can start the refresh of the dataflows at 8 in the morning. Let's guess the frefresh takes 10 minutes. Then you can plan the refresh of the dataset at 8:30.

 

You could also trigger the fresh in Power Automate or with the REST API. But there you have to think about a mechanism that is checking every minute if the refresh is finished and then start the refresh of the data set.

 

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
 

Ok thank you!

Is there a way to, via Power Automate, refresh all de dataflow it once time and wait 30 minutes and then refresh the Dataset?

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors