cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Frequent scheduled refresh failures

We are seeing frequent failures of scheduled resfreshes with an error of "The gateway is either offline or could not be reached", but upon (repeated) investigation, there is no apparent problem with the gateway or network connectivity on our end. The next refresh will succeed. The GW shows up as online and "good to go" in Power Bi service.

 

This is happening with datasets coming from SQL server and from web services. We've tried restarting the GW, upgrading, reinstalling, restarting the server, etc. it makes no difference.

 

At about the time of the failure, the main log shows a suspicious-looking "[DM.GatewayCore] Async operation ... 1 transitioned into Cancelled state after 300 seconds timeout" and the error log shows several "DM.EnterpriseGateway Error: 1  ... [DM.NetworkCore] Non-gateway network exception encountered in activity scope: System.ServiceModel.CommunicationException: The socket connection has been disposed. ---> System.IO.IOException: The write operation failed, see inner exception. ---> System.ServiceModel.CommunicationException: The socket connection has been disposed. ---> System.ObjectDisposedException: Cannot access a disposed object." errors.

3 REPLIES 3
Highlighted
Super User III
Super User III

Hi there

 

Are there any issues with network connectivity from your server to the Power BI Service?

 

Also are the disks in the server good to go? It might be a disk issue that is intermitently causing the errors?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Highlighted
New Member

Did you find a solution to this problem?

Highlighted

No, we still frequent failures. It improved significantly in mid September through mid October. I didn't see any failures from Sep 17th until Oct 12th. Failures ramped up again after that and we are now back to at least 2-3 failures a day.

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors