topic Re: Identify/extract Data Sources using PersonalGateways in Developer

Identify/extract Data Sources using PersonalGateways

pvuppala — Mon, 02 May 2022 15:00:45 GMT

Hello Gurus,

We're going through some Personal Gateways and its usage. We finally turned off the PersonalGateway installs using this simple command

Set-DataGatewayTenantPolicy -PersonalGatewayInstallPolicy Restricted

Also, I am able to identify all existing PersonalGateways via a combination of these commands

Get-DataGatewayCluster -Scope Organization | Where-object {($_.Type -eq "Personal") }

Next step is to idenfity all or any datasources/workspaces these personal gateways are being consumed. Any ideas on how to proceed?

TIA.

Re: Identify/extract Data Sources using PersonalGateways

lbendlin — Thu, 05 May 2022 00:31:07 GMT

What's your rationale for caring about that?

Anyway, the tenant audit logs have sections for gateway connection creation/modification. As far as I can tell that includes personal gateways.

Re: Identify/extract Data Sources using PersonalGateways

pvuppala — Thu, 05 May 2022 03:36:42 GMT

The idea behind is to stop folks installing Personalmode and go through an Enteprise Data Gateway for compliance reasons etc., We as admins trying to put some guardrails on data sources to make sure customers follow this process.

Re: Identify/extract Data Sources using PersonalGateways

lbendlin — Thu, 05 May 2022 10:48:00 GMT

We solve that differently - by offering the users the option to use our enterprise gateways that have much better performance, guaranteed uptime ( with multiple cluster members each) and full sets of connection drivers.

Don't forget that personal gateways are required for R and Python scheduled refreshes.

Re: Identify/extract Data Sources using PersonalGateways

pvuppala — Mon, 09 May 2022 02:12:56 GMT

Thats exactly what I mean't when I said to we're planning to have all customers go through Enterprise gateways 🙂 For now, I'm still looking to identify what content is using Personal Gateways so we can notify the customers. I'm meeting our MS support next week so I will update on our working session.

Re: Identify/extract Data Sources using PersonalGateways

Anonymous — Wed, 11 May 2022 08:14:44 GMT

Hi @pvuppala ,

Please check if REST API Gateways - Get Datasources is what you want...

GET https://api.powerbi.com/v1.0/myorg/gateways/{gatewayId}/datasources

Best Regards