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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Jon_S
Frequent Visitor

Gateway refreshes failing

Since mid-July, we have an automated refresh that has been failing every single day.  Prior to that, it had worked every day for 6 months.  When manually refreshing, it fails with the same error message ~4 out of 5 times.   The other time it works.  As a result, each day we have been manually refreshing this model until it doesn't error out. 

 

We have tried the following and none of the resolve the issue:

  • Upgrade the virtual machine to a faster instance type
  • Restart the gateway service
  • Install the latest gateway version 
  • Stand up a new virtual machine and install the gateway, make new connections

 

When testing the status of the gateway and the connection, they always show as online.  The ODBC connection on the machine is working.  

 

What is causing this and what steps should we take next?

 

Jon_S_0-1724075074022.png

 

1 REPLY 1
lbendlin
Super User
Super User

When testing the status of the gateway and the connection, they always show as online.

That doesn't mean much.  The network tests on the gateway management app are largely pointless as they do not reflect the actual workings of the gateway.

 

How many cluster members? are they all equally configured and equally healthy?

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Feb2025 NL Carousel

Fabric Community Update - February 2025

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