Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply
mgiusto
Helper I
Helper I

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

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: 

 

mgiusto_0-1641306691128.png

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

1 ACCEPTED SOLUTION
mgiusto
Helper I
Helper I

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

View solution in original post

4 REPLIES 4
mgiusto
Helper I
Helper I

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

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
Community Support
Community Support

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
Impactful Individual
Impactful Individual

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


Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors