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