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:

Governance & administering

I have the same question (0)

All responses (9)

Answers (1)

AlbertoCastro 1,201 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No
stanislawW 12 on at

Like (0)

Report
Copy link

Link copied!

Hi,

Its Standard one, installed on one of our server

Was this reply helpful? Yes No
AlbertoCastro 1,201 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Can you share any screenshot to understand better the problem?

Was this reply helpful? Yes No
stanislawW 12 on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
AlbertoCastro 1,201 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

To confirm, You share the gateway with the user with this settings, do you?

Was this reply helpful? Yes No
stanislawW 12 on at

Like (0)

Report
Copy link

Link copied!

I only have option to choose one connection type when creating and it is selected as SQL server :

Was this reply helpful? Yes No
AlbertoCastro 1,201 Most Valuable Professional on at

Like (0)

Report
Copy link

Link copied!

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:

Was this reply helpful? Yes No
stanislawW 12 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

AlbertoCastro 1,201 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No