gateway issue - cluster setup
Hello, For a long time, our Power BI gateway server has run without any issues. We recently added a second server to run in parallel with it. Installation was straightforward, and the new server is now part of the gateway cluster alongside the existing one. During testing, we found that the new server cannot access Microsoft SharePoint locations and returns a timeout error. The only notable difference between the two servers is that the new one is hosted in a different data center. Network tests confirm that the server can reach SharePoint without any problems at the network level. Thanks in advance for your feedback. You can find the error message as follows: Error codeDMTS_GatewayIsDisabled, DM_GWPipeline_Gateway_MashupDataAccessError Connection errorUnknown error Cluster URIhttps://api.powerbi.com Session IDfd08afc6-2ed7-41e3-b713-3fe23d79f9e3 Request ID16a0a7d4-aa10-4818-b2cc-af1cc11fe871 TimeMon Sep 28 2026 11:40:16 GMT+0200 (Central European Summer Time) Enterprise Data GatewayGateway is disabled --> this is the old server, which we disabled to test the new one DataGateway3243Received error payload from gateway service with ID 739060: The mashup query execution timed out.
Gateway Unreachable
All are failing on Scheduled Refresh All reports work when manually refreshing. I have checked Gateway Status and I have chcked Connection to SQL Server. Cluster URIWABI-US-NORTH-CENTRAL-J-PRIMARY-redirect.analysis.windows.net Activity ID90a01224-d153-4fcb-836b-c4a3d71bd363 Request ID4ea3aefd-6daa-4b58-9b5e-c8e0c2be186a Time2025-11-22 16:35:01Z { "error": { "code": "DM_GWPipeline_Client_GatewayUnreachable", "pbi.error": { "code": "DM_GWPipeline_Client_GatewayUnreachable", "details": [ ], "exceptionCulprit": 1, "parameters": { } } } }
2 Gateways, one Fabric warehouse
Hi Everyone, I have a problem with reports. From what I know, I can only use 1 on-premises gateway in 1 dataset in PBI. Understood. But having MS Fabric, can I pull the data from 2 different gateways to store it in Fabric data warehouse? In this DWH, I already have data from server A, but when trying to access server B, I get such error message: Can you please help me to solve this? From what I know, I need to have different gateways on these 2 servers, right? I need to combine data from server A and B, have relations set in PBI model and allow these reports to refresh automatically. Seems very strange for me that I cannot combine 2 different data sources into data warehouse, since it is one of the principal ideas of DWH - to combine data from different sources. Any ideas? What's important. The credentials I use for accessing this 2nd server via Fabric DataflowGen2 are the same as I use in MSSQL to pull data manually from server. And in MSSQL, it works just fine. Also, when creating PBI dataset that contains data only from this Gateway (server), I can set refresh as well. But I need to combine data from 2 gateways, and here's the problem. Many thanks in advance for any help!
