Showing results for 
Search instead for 
Did you mean: 
Helper II
Helper II

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?



Community Support
Community Support

Hi @pvuppala ,

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



Best Regards

Community Support Team _ Rena
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Helper II
Helper II

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.

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

September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors