Solved: Automate Refresh on failure of scheduled refresh

Anonymous · ‎07-29-2020

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 · ‎07-29-2020

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

View solution in original post

Greg_Deckler · ‎07-29-2020

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

@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!: The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...

Anonymous · ‎07-30-2020

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

Thanks

Anonymous · ‎07-30-2020

Would this work with an on premise Report Server?

Automate Refresh on failure of scheduled refresh

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024