Power BI Product Team present | On-Prem Gateway Monitoring & Troubleshooting
A challenge faced by Power BI Admins is how-to monitor & troubleshoot multiple on-premises Data Gateway Clusters. With each cluster having multiple servers that are responsible for connecting their data sources to the Power BI service in the cloud, investigating errors or performance issues across the gateway logs can become a complex task. This presentation aims to show a solution to help Power BI admins to: • Quickly access all gateway logs • Explore the gateway logs to get insights to help you take the most out of your Power BI gateways
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": { } } } }
Username and Password not working to connect Gateway
We have a PowerBI gateway to Databricks that username and password stopped working in the beginning of October. We have tried multiple users with access, and verified passwords have not expired, and we are getting: "PowerBI: [Microsoft][ThriftExtention](8) Authentication/authorization error occured. Error details: Bad status with no error message: Unauthorized/Forbinne: Status Code: 403" These same accounts are able to use access keys from Databricks to connect the gateway, but not username and password. All these accounts have full access to the Connector, PowerBI and Databricks. Some people with similar issues said to reenter credentials, this has not worked and we cannot use credentials at all... Only Access Token. Anyone input would be appreciated.
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!
