Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
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 |
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?
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)