Forum Discussion
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
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
4 Replies
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 regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicOk 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?
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.
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.
