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!
