Automate Refresh on failure of scheduled refresh

[Anonymous]

I'm trying to see if there's a way to run a refresh of a single report that fails on a shared schedule. Basically trying to avoid running all the other reports that are attached to the same schedule. I have some TSQL that gives me the GUID of the failed report, but not sure to run the refresh. 

Thanks

[Greg_Deckler · Accepted solution]

@Anonymous - Should be able to use Power Automate for that (Flow).

[Anonymous]

I haven't used that yet, but I'll give it a shot.

Thanks

[Anonymous]

Would this work with an on premise Report Server?