Data Gateway Refresh Error

whitneyburr — Thu, 14 Dec 2023 16:54:50 GMT

I've read the other posts on the forum and none seem to have been drawn to a conclusion.

Since approximately March 2023 we've had an increase in scheduled refresh failures via our data gateway. I regularly go on and make sure it is up to date. An update will alleviate some of the refresh errors for a couple days, but it soons returns to failure. We are having to consistently manually go through and run refreshes on the data in order for end users to interact with their dashboards. When manually refreshing, it will work more often than not, but there are also failures with the connection then.

Is there a resolution to this?

This is an error message I got this morning while trying to push a refresh manually:

Last refresh failed: 12/14/2023, 10:31:39 AM
There was an error when processing the data in the dataset.Hide details

Data source error:	{"error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","pbi.error":{"code":"DM_GWPipeline_Client_GatewayUnreachable","parameters":{},"details":[],"exceptionCulprit":1}}} Table: Query1.
Cluster URI:	WABI-US-NORTH-CENTRAL-G-PRIMARY-redirect.analysis.windows.net
Activity ID:	2fd6f1ec-a4c7-410d-8e67-b77b4f2d9e75
Request ID:	0d98aa65-56e0-5f82-6f96-cc1e9ecac571
Time:	2023-12-14 16:31:39Z

Re: Data Gateway Refresh Error

GilbertQ — Thu, 14 Dec 2023 22:19:46 GMT

Hi whitneyburr

I would suggest chatting to the person who owns your gateway virtual machine to check to see if there are any hardware issues with regards to your gateway.

Could you also cheque that you have the latest version of the Power BI gateway installed?

Re: Data Gateway Refresh Error

whitneyburr — Thu, 14 Dec 2023 22:27:22 GMT

Our server is in line with these requirements: Install an on-premises data gateway | Microsoft Learn

The gateway is version: 3000.198.9 (2023-11-03)

topic Re: Data Gateway Refresh Error in Service

Data Gateway Refresh Error

Re: Data Gateway Refresh Error

Re: Data Gateway Refresh Error