Monitoring vnet data gateway service and statistics

[mrflinstone]

Hi All.

I was wondering if it is possible to monitor the vnet data gateway service for downtime and performance statistics. We are experiencing performance issues when refreshing reports and the vnet data gateway is one area that requires further investigation.

I just was not sure if it is possible to interrogate the vnet data gateway from powershell or have access to some form of dashboard with performance statistics.

[Anonymous]

Hi, @mrflinstone 

You can download logs directly from the Power BI service. Go to the Manage connections and gateways page, select the Virtual network data gateways tab, and then locate the VNet data gateway. You can download diagnostic logs, which include system counters, mashup logs, and query execution reports. You can check the following link:

Download logs on the VNet data gateway | Microsoft Learn

You can use PowerShell to retrieve performance statistics. First, use Connect to an Azure subscription. Connect-AzAccount can then retrieve the data gateway resource group and name to get the necessary performance data.

VNet Data Gateway in Power BI: Retrieving Performance Statistics (devcodef1.com)

Azure Monitor can be used to collect and aggregate metrics and logs from your VNet data gateway. This service provides a comprehensive view of availability, performance, and resiliency and can notify you of any issues. You can refer to this link:

Monitor Azure Virtual Network | Microsoft Learn

How to Get Your Question Answered Quickly

Best Regards

Yongkang Hua

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[mccloudy]

"You can use PowerShell to retrieve performance statistics. First, use Connect to an Azure subscription. Connect-AzAccount can then retrieve the data gateway resource group and name to get the necessary performance data. VNet Data Gateway in Power BI: Retrieving Performance Statistics (devcodef1.com)"

Any ideas on why my $performanceStats would be empty? I'm an admin on the gateway etc... 

[aj1973]

Hi @mrflinstone 

I also couldn't find any documentation in regards Monitoring the Vnet however I can suggest to try this template

 https://learn.microsoft.com/en-us/data-integration/gateway/service-gateway-performance

If you can use the end point url of your Vnet and hopefully it has the same structure as the on pemises logs gateway. But I believe you can be able to build your own report with Power BI desktop if you can connect to the Vnet end point.

[Vishnu1995]

hello, did anyone try out this option?