Data gateways allow users to connect online services, such as Power BI service, Power Automate, and Power Apps to on-prem data sources such as SQL databases, SharePoint server lists and libraries, and network shares.
As you can imagine, you wouldn’t want everyone installing their own individual gateways throughout your organization. Managing and sharing those centrally is much more efficient (and secure). You can manage who is allowed via the Power Platform admin center at admin.powerplatform.microsoft.com.
Note: You must be one of these roles to restrict gateway installers:
- Azure AD Global administrator
- Office 365 Global admin
- Power BI service administrator
Restricting installations does not impact gateway administration. You can assign and re-assign users to administer and use gateways at any time. The following steps are strictly to manage who is able to install an enterprise gateway on a machine.
1. Go to the Power Platform admin center
2. Click “Data gateways”
3. Click “Manage gateway installers”
4. Toggle “On” the Restrict users in your organization from installing gateways
5. Add authorized users.
In just a few clicks, you’ve enabled better management of enterprise access to on-premises data sources for scheduled data refreshes, apps, and flows.