Showing results for 
Search instead for 
Did you mean: 
New Member

How do you share an on-premises data gateway

I created a flow that connects to SQL through an on-premises data gateway. I shared this flow with a user. I go to Data > Gateways  and share the gateway with "Use" permissions. I even went to Power Apps and Power BI and shared the gateway, yet he still gets "you do not have permissions for the on-premises data gateway. Please request permissions from the owner of the gateway". What am I missing here. 

Community Support
Community Support

@Ichinova : To corner down the issue quickly, go to PowerBi -> Settings icon -> Manage Gateways and add the user account to the administrator and confirm if the user can view the GW as expected.


Manage an on-premises data gateway | Microsoft Docs


If this works, only cause of the issue would be the user permissions are not correctly shared.

To share and manage gateways from your apps, follow these paths;

  • Power Automate –> Settings wheel –> Gateways
  • Power Apps –> Data –> Gateways
  • Power BI –> Settings wheel –> Manage gateways

If the issue still occurs, try for different user, Keep us posted if the issue still occurs.

New Member

Ok I increased his permissions to admin in all the specified areas. I'll post back if this works. I know the gateway does work because there are a few of us using it, so just need to figure out what this one user is missing. 

New Member

Well I gave him Admin permissions and it worked. I guess that's fine, but still don't understand why the regular permissions don't work. 

Helpful resources

Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

New Ideas Forum MPA.jpg

A new place to submit your Ideas for Power Automate

Announcing a new way to share your feedback with the Power Automate Team.

MPA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

Learn to digitize and optimize business processes and connect all your applications to share data in real time.

Super User 2 - 2022 Congratulations 768x460.png

Welcome Super Users

The Super User program for 2022- Season 2 has kicked off!

Users online (2,921)