On premise data gateway - gateway not visible for normal user?

(0) Share

Report

Posted on by stanislawW

Hi,

I have gateway that works just fine for Powerbi -> i want to use with powerapps.

I tried to connect Microsoft SQL -> i change to Windows Authecation and the gateway is not visible. That happens when i login as normal user, when i login as admin - i can see the gateway option normally.

Of course i have shared connection with my normal user account -> and also with someone else to test but still nothing.

What should i check now?

Categories:

Environment

Management

All responses (9)

Answers (1)

Verified answer

AlbertoCastro 1,184 Most Valuable Professional on at

Like (1)

Report

Re: On premise data gateway - gateway not visible for normal user?

Exactly! The behaviour in power automate/power apps is different. In these case you share the gateway to use by the user when create the conecion in his app or flow.
-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.
Regards
Alberto
stanislawW 12 on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

So in powerapps i need to share gateway with user? Because with Powerbi i only needed to share connection -> gatewat access was only given to admins?
AlbertoCastro 1,184 Most Valuable Professional on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

mmm last screenshot is about a connection to use in a power bi dataset.

To share a datagateway with an user, you must to go to here:
https://admin.powerplatform.microsoft.com/ext/DataGateways

Select the datagateway and click in Manage users:
After this, you could look for your user and grant the permissions to use the gateway in power apps/power platform:
stanislawW 12 on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

I only have option to choose one connection type when creating and it is selected as SQL server :
AlbertoCastro 1,184 Most Valuable Professional on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

To confirm, You share the gateway with the user with this settings, do you?
stanislawW 12 on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

No problem. So when i go to make.powerapps as admin user, choose connection sql server connection, change to windows authecation i see then gateway at the bottom:

If i do the same as an normal user with powerapps developer license i dont see gateaway as option:
AlbertoCastro 1,184 Most Valuable Professional on at

Like (1)

Report

Re: On premise data gateway - gateway not visible for normal user?

Can you share any screenshot to understand better the problem?
stanislawW 12 on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

Hi,

Its Standard one, installed on one of our server
AlbertoCastro 1,184 Most Valuable Professional on at

Like (0)

Report

Re: On premise data gateway - gateway not visible for normal user?

Hi,
are you using a personal or standard data gateway?
https://learn.microsoft.com/en-us/power-apps/maker/canvas-apps/gateway-reference#types-of-gateways

If it's a personal data gateway only works with power bi