topic Re: Automate Refresh on failure of scheduled refresh in Report Server

Automate Refresh on failure of scheduled refresh

Anonymous — Wed, 29 Jul 2020 19:25:50 GMT

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

Re: Automate Refresh on failure of scheduled refresh

Greg_Deckler — Wed, 29 Jul 2020 20:46:23 GMT

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

Re: Automate Refresh on failure of scheduled refresh

Anonymous — Thu, 30 Jul 2020 12:17:34 GMT

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

Thanks

Re: Automate Refresh on failure of scheduled refresh

Anonymous — Thu, 30 Jul 2020 12:42:26 GMT

Would this work with an on premise Report Server?