[CoE Starter Kit] On Premise Data Gateway Usage

[manuelap-msft]

Can you add metrics and utilization on On-Premise data gateway usage?

[manuelap-msft]

I believe the only info we have is if an app uses on premise gateways. We can add reporting for that and investigate what else is available.

[Jenefer-Monroe]

blocked by lack of product APIs. put in backlog awaiting these

[petepuu]

@manuelap-msft, @Jenefer-Monroe We can get gateways at least using custom connector and Power BI REST API. https://learn.microsoft.com/en-us/rest/api/power-bi/gateways/get-gateways

Checked Power App connection using gateway in PowerShell Get-AdminPowerApp and gateway ID is there in the connection info. But I think this level of info is not returned by "Get App as Admin" action of Power Apps for Admins connector. Wondering why there is a difference between that connector and PowerShell cmdlet

Documentation is for v1.0 but there seems to be v2.0 API available as that is what PPAC is using to get gateways. v1.0 seems to return only standard gateways but v2.0 also personal and VNET gateways. I created simple custom connector just for testing is this working and can share that with you if needed

v2.0 endpoint is _ttps://api.powerbi.com/v2.0/myorg/gatewayclusters

[Jenefer-Monroe]

Thanks for the lead on direction here!

[DamoBird365]

Hey folks, I have come hunting for a similar answer, are there plans for the CoE to support reporting on Data Gateway usage in Flows/Power Apps? Thanks

[Jenefer-Monroe]

Thanks for expressing your interest! This hasnt popped yet into our priority stack (we are a very small team) but hearing from people that they want this helps!

[v7herman4]

The information is available in json returned for for: Connector: Power Apps for Admin Action: Get Connections as Admin

[FacilyDev]

As a PowerPlatform admin for the company, I came across this issue. Any news/hints how to get the usage of on-premises data gateway by PowerAutomate (Flows)?

[joshjacquet]

Adding +1 to this.

We're relatively new to the CoE/Apps/Automate and having easier visibility into connection-level usage of the gateways is big.

We are used to the management of gateways/connections on the Power BI side, looking for the same level of support on the Apps/Automate side.

I have noticed that maybe the level of detail I'm looking for is specifically for the SQL Server connector, and that other calls to Get Connections as Admin don't appear to have the gateway info for those. For these connectors the gap might still exist. In the interim we are likely to spin up a side project to gather and reference gateway logs themselves.