Forum Discussion
Solution SageAutomated action after the dataset has refreshed
Super UserThere is no trigger. Everything is done via polling.
Solution SageOk 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.
- rpinxt
Ok....well then I think this will lead me nowhere because I even don't have this one:
We will have to look into other options to automatically export our report as a pdf and save it to a local folder.
Thanks lbendlin for your time.
- lbendlin
for that part you can use the standard action (but you lose the Enhanced Refresh API options)
This only requests the refresh, there is no feedback on when it ends and if it was successful.