How to increase number of failures before disabling scheduled refresh

[bensavelli]

Hi,

I often have power BI reports that do not complete sceduled refreshes for whatever reason ("There was an error when processing the data in the dataset."). After a few errors in a row, it disables the sceduled refresh ("data refresh has been disabled.").

I would like to increase the number of attempts needed to activate this disabling. Ideally in terms of time rather than attempts. For example, sceduled refreshes should keep trying unless it's been a week of failing.

Any help would be nuch appreciated.

Thanks 

[lbendlin]

A word of warning - from personal experience - automatic retries a evil. They create uncontrollable CU cost.

[v-yingjl]

Hi @bensavelli ,

Please note that:

Spoiler

Scheduled refresh failures

If a scheduled refresh fails four times in a row, Power BI disables the refresh. Address the underlying problem, and then re-enable the scheduled refresh.

Spoiler

Scheduled refresh timeout

Scheduled refresh for imported datasets timeout after two hours. This timeout is increased to five hours for datasets in Premium workspaces. If you encounter this limit, consider reducing the size or complexity of your dataset, or consider breaking the dataset into smaller pieces.

The number of scheduled refresh fail in power bi service is 4 currently and we cannot change it. If your refresh fails, you need to check the refresh history to find the problem, try to solve it and re-enable the scheduled refresh if it has been disabled.

You can also submit this idea to add your comments there to make this feature coming sooner: 
It is a place for customers provide feedback about Microsoft Office products . What’s more, if a feedback is high voted there by other customers, it will be promising that Microsoft Product Team will take it into consideration when designing the next version in the future.

Best Regards,
Yingjie Li

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[bensavelli · Accepted solution]

I have submitted the idea here

Please upvote, thanks

[lbendlin]

unless your data source is sharepoint (which has known issues with scheduled refresh) you should really worry more about why it is failing so frequently, and in a row. Think of the impact the failed refresh attempts have on your capacity's resources.

[JKrug60]

In our case, the failures are typically a result of planned maintenance shutdowns on one or more of our source file locations.  Whenever the shutdowns exceed the refresh interval x 4, I have to manually restart every model, which can be time-consuming.