cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Automate Refresh on failure of scheduled refresh

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

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Super User IX
Super User IX

Re: Automate Refresh on failure of scheduled refresh

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

3 REPLIES 3
Highlighted
Super User IX
Super User IX

Re: Automate Refresh on failure of scheduled refresh

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


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




View solution in original post

Highlighted
Frequent Visitor

Re: Automate Refresh on failure of scheduled refresh

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

 

Thanks

Highlighted
Frequent Visitor

Re: Automate Refresh on failure of scheduled refresh

Would this work with an on premise Report Server?

Helpful resources

Announcements

August Community Highlights

Check out a full recap of the month!

Experience what’s next for Power BI

Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.