Forum Discussion

luis-martins's avatar
luis-martins
Helper I
5 years ago
Solved

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 Pow...
Dataflow
Need Help
  • selimovd's avatar
    selimovd
    5 years ago

    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
     
ajerovich's avatar
ajerovich
Advocate II
3 years ago

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.