Power BI Gateway informations

[kim0]

Hello! I've been researching to figure out existing gateways within Enterprise Power BI. However, I am facing the issue with the correct numbers existing inside Power BI.

According to the Power BI portal and API calls from 

https://api.powerbi.com/v2.0/myorg/gatewayclusters?`$expand=memberGateways&`$skip=0

  I have around 300 gateways existing within the Power BI. However, When I query datasource existing in Power BI and see their linked Gateway_IDs, then they have about 1000+ distinct gateway_ids.

I used "Get-PowerBIDatasource" function module in Powershell to grab datasource information from existing datasets in Enterprise.

Are distinct gatewayIDs representing not only PowerBI gateways, but also other gateways? (such as powerapp, sharepoints, and many other)

I just want to count the number of gateways created for Power BI.

[rajendraongole1 · Accepted solution]

Hi @kim0 - The Gateway_ID field from Get-PowerBIDatasource doesn't just represent Power BI gateways. It also includes entries for:
Gateways for PowerApps.
Other linked services like SharePoint, Azure Data Factory, or Logic Apps.
Historical or deprecated gateways that might still be linked to older datasets.
Thus, the higher number of distinct Gateway_IDs could reflect a broader scope of data connections, not just physical or logical gateways used exclusively for Power BI.

Filtering based on ConnectionType and cross-checking with active clusters from the Power BI REST API should give you a more accurate count of gateways used exclusively for Power BI.

Reference links:

https://community.fabric.microsoft.com/t5/Community-Blog/Get-Gateway-related-information-Via-PowerSh...

https://www.serverlessnotes.com/docs/list-gateways-power-bi-rest-api

Hope this helps

[kim0]

Thank you so much for reference documentation. The additional reference gave me clear instructions!

Let's say I do have only PBI Admin role under the enterprise and I can only get Power BI Gateway counts. How can I determine rest of logical gateway counts? (How to tell these gateways are from what platform)