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?

avatar user

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!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Solution Authors (Last Month)
Top Kudoed Authors (Last Month)