Refresh failed: Since the new year (2022) most of my datasets are failing to refresh.

[mgiusto]

Returning back from new years break I am finding that most of my datasets are failing to refresh, the error on each one of them is the same: 

I was able to go to each one and after a few manual refreshes got them to update, but this morning all the scheduled refreshes failed again. Is anyone else experiencing similar issues?

Thanks for any help.

Michael J. Giusto

[mgiusto · Accepted solution]

All:

The issue was the server the data gateway was installed in was unusually slow, a reboot of this server resolved the issues!  Thank you very much for your ideas on what it could be!

Best regards,

Michael J. Giusto

[v-chenwuz-msft]

Hi @mgiusto ,

I'm glad your problem was solved, please mark it as a solution so that anyone with the same problem as yours can find a quick answer.

[v-chenwuz-msft]

Hi @mgiusto ,

Does it scheduled refresh successfully now?

It can be manually refreshed successfully, then scheduled refreshes are fine unless there are other reports being refreshed or other users viewing the report at the same time as the scheduled refresh, causing the refresh to run out of resources and thus causing a failure. Please ensure that the gateway is online during the refresh period or try changing the scheduled refresh period.

Best Regards

Community Support Team _ chenwu zhu

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

[itchyeyeballs]

How big are your datasets and are you going through a gateway?

If datasets are coming from a local database then check with the DB admin if there are any load issues, the fact you can manually get them to refresh eventually seems to indicate the data source (or another step on the local network) is struggling with load