topic Re: Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac in Report Server

Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac

petersenpedrog — Mon, 09 Sep 2024 16:53:47 GMT

I'm experiencing issues with the scheduled refresh on my Power BI dashboards. I have six published dashboards that have been running smoothly since January, but since last week, I've been encountering gateway errors. My gateway starts running at 12:10 AM, followed by a scheduled refresh at 1:30 AM. However, only one dashboard completes the refresh, while the others crash. Interestingly, I have another scheduled refresh at 1:30 PM, and this one runs without any problems.

While reviewing the error logs, I found the following:

DM.EnterpriseGateway Error: 1 : 2024-09-06T04:31:30.3353144Z DM.EnterpriseGateway [DM.NetworkCore] Non-gateway network exception encountered in activity scope: System.ServiceModel.CommunicationException: The socket connection has been disposed. Timestamp:2024-09-06T04:31:30 ---> 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.

This error occurred exactly when my dashboards were scheduled to refresh. Can anyone help me understand what's going on?

Re: Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac

lbendlin — Mon, 09 Sep 2024 18:56:18 GMT

My gateway starts running at 12:10 AM,

What made you choose that? Why not keep it running 24x7 ?

Are you on Atlantic time?

Re: Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac

petersenpedrog — Mon, 09 Sep 2024 19:27:08 GMT

Due to company preference, it was decided that the machine would turn on at 12:00 AM and turn off at 2:00 AM. My ETL finishes running at 1:00 AM, and my Power BI updates at 1:30 AM, with the update finishing around 1:45 AM. I am not in the Atlantic time zone.

Re: Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac

lbendlin — Mon, 09 Sep 2024 19:31:54 GMT

The reason I was asking was that the error showed it as 4:31 UTC

2024-09-06T04:31:30.3353144Z

Recommendation would be to keep the gateway running for testing purposes and see if the error goes away.

Re: Gateway Error - Can't Refresh Published Dashboards : Non-gateway network exception encountered in ac

Anonymous — Wed, 11 Sep 2024 06:19:08 GMT

Thank you lbendlin

Hi, petersenpedrog

Do you use the verification method in the image below:
Microsoft Entra ID OAuth？
In this case, the data loading process may fail due to a credential error (the problem you are experiencing).
Usually the workaround for this error is:
Make sure your refresh time is less than an hour and optimize its datasets/queries for this data source.

Troubleshoot refresh scenarios - Power BI | Microsoft Learn

In addition, you can view the error information from the logs of the on-premises data gateway by following the document below

Troubleshoot the on-premises data gateway | Microsoft Learn

Follow the following documents to test the gateway's network:

Adjust communication settings for the on-premises data gateway | Microsoft Learn

Later, if you find more useful error information, it will help troubleshoot the core of the error.

Best Regards

Jianpeng Li

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