A Power BI Gateway Monitoring & Troubleshooting Solution
One of the main challenges I see #powerbi admins of large enterprises is monitoring & troubleshoot all their on-prem Gateway Clusters.
Each cluster has multiple gateway servers that are responsible to connect the Power BI service in the cloud to customer data sources, sometimes there are errors in that process and the only way to correctly troubleshoot the issue is looking into the gateway logs.
The problem is that sometimes #powerbi admins don't have permission to remote desktop to the Gateway Server and download the logs and even if they do it might be challenge when dealing with multiple gateway servers...
So, to ease the pain of these #powerbi admins I created a simple open-source solution that require admins to publish a simple & lightweight #powershell script to each gateway server that incrementally send & classify (by gatewayid, log type, timestamp) the gateway logs to a central storage account allowing admins to:
- Easily access all the gateway logs without having to remote access to the gateway server
- Explore the logs with a Power BI Report
- Explore the logs using a SPARK / Data Explorer Engines in Azure Synapse Analytics
In the end you can just explore the logs using Azure Portal or Azure Storage Explorer:
Or using a built-in Power BI template:
Download solution & setup instructions here
Data Engineer at Amazon
6moIs anyone able to successfully implement "disk template" i.e. "Gateway Monitor - FromDisk.pbit" from Rui's solution? Rui Romano, I pointed the disk template to our export logs folder and tried to load data. Left rest of the parameters to default. It threw "OLE DB or ODBC error: Exception from HRESULT.." error on many queries and "OLE DB or ODBC error: [DataFormat.Error] We found extra characters at the end of the JSON input.." error on Mashup Container Profile query. Is there anywhere you think I might have gone wrong?
Improving Technical Processes to Enhance Organizational Success
1yIs there a version of this which would load to an on-premises SQL Server database and a pdix that would source from that?
Senior Manager at Federated Hermes
1yRui, out of curiosity, do you have any monitor to show whether a gateway and a datasource are online? I know that these dashboards are connected to a data source that may be cached but seeing if this possible.
Managing Director GNAK Consulting GmbH (BI, Software Development, Project Management) | MBA Candidate at University of East London | Rheinische Hochschule Köln
1yRui Romano, great solution. Thanks .