How to Persist Refresh Schedule Through Failures?

[JBorja]

Hello,

My organization's network shut down for nearly 24 hours, causing all reports with frequent refreshes to fail and consequently disable the automatic refresh schedule.

I've reactivated all schedules, but this was a bit tedious since there are several reports following the same schedule.

Is there a way to persist the automatic refreshes through failures? Otherwise, do you have any advice for making it easier to turn the schedules back on next time this might happen?

Thanks!

Julian

[GeraldGEmerick · Accepted solution]

@JBorja You could possibly use the Power BI REST API or the Powershell commandlets for Power BI. Datasets - Update Refresh Schedule - REST API (Power BI Power BI REST APIs) | Microsoft Learn

[JBorja]

@GeraldGEmerick this looks like it will work. Thank you!

[GeraldGEmerick]

@JBorja My pleasure!