Forum Discussion
Solution SageAutomated action after the dataset has refreshed
Super UserYou can accomplish that in Power Automate by either polling the refresh history (check the presence of an End Date for the most recent entry) or by using a custom connector to initiate an enhanced refresh. That will give you a request ID which you can then use in API calls to ask for the status.
Solution SageThanks lbendlin however I cannot find "Refresh Dataset in Group".
Guessing that is not the trigger?
When setting up a flow I am asked to choose flow's trigger.
This option is not there.
Where the trigger in my opinion would be to see if a dataset changed.
- lbendlin
There is no trigger. Everything is done via polling.
- rpinxt
Ok lbendlin , but sorry then I do not understand.
My understanding of Power Automate is not very big.
Guessing your solution then works totally different then other power automate flows.
Even not sure if I would achieve what I was after with your solution.
I have a report published (also in dekstop) that is on auto refresh.
My goal was to whenever this report was refreshed (so the new data was in) it would get exported as a pdf to a local folder.
(Probably sounds lot simpler then it will be in practice 😉 )
- lbendlin
Power Automate has a standard "trigger" for "when a dataflow refresh completes". It does not have anything equivalent for "when a dataset refresh completes". You will need to write your own process - as I have shown earlier in the post. Keep in mind that "completes" doesn't mean much. You also have to check the result - did it fail or did it succeed? There may not be a need to continue if it failed (or you may choose to re-request a refresh).
You touched on a much deeper, more philosophical question though. Nothing in Power Automate is genuinely triggered. Deep down everything is implemented through polling.