Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
pvuppala
Helper V
Helper V

Identify/extract Data Sources using PersonalGateways

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") } 

 

 

 

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.

5 REPLIES 5
Anonymous
Not applicable

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

yingyinr_0-1652256872254.png

Best Regards

pvuppala
Helper V
Helper V

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.

lbendlin
Super User
Super User

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.

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.

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.

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

Check out the June 2025 Power BI update to learn about new features.

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.