How to give permission to add gateway?

[cha1234]

Hello everyone

I made a powerbi for my company, and shared it on apps.powerbi.com, but I need a gateway installed because I use a local SQL server for data.

To add the gateway, I need give permission to my IT leader so he can add it, I used to be able just "share" with him and he has successfully added it before.

It seems powerbi had a recent update? and this won't work anymore, I tried all the ways to share, checking all boxes and nothing works. He still has "no access".

Helps are greatly appreciated.

[kdmishra · Accepted solution]

Logged in as an Admin, go to the Cog in the top right corner. Select "Manage Gateways". 

Select Manage Gateway installers. If your restricted users button is set to on, then you will need to add the IT Leader email address.  The IT Leader will need to go here: https://powerbi.microsoft.com/en-us/gateway/ to download and set it up. 

They should also have Power BI app assigned to them through Office 365 or however your are managing general access (in some cases, they can use a trial version). 

Best of luck!

Kristina

[cha1234]

Thank you for the reply!

Do you mean log in as Admin on app.powerbi.com? How do I do that?

But as you instructed:

I did go to  "Manage Gateways". 

But it says I have no gateway,

So I should let my IT leader know, he needs go : https://powerbi.microsoft.com/en-us/gateway/  ? And download gateways? 

(we have added gateways successfully before, without all this work. Would you happen to know why the process changed so much for now?)

[dhruvinushah]

Hi, @cha1234 

Data gateways are created to connect to specific sources of data to the Power BI service. If you are selecting the data gateway for a production server in the Power BI workspace, when your report needs to connect to the local SQL Server that has not been added to the service , your power bi service report won't be able to connect to the Local SQL Server that houses your report's data. 
Possible solutions: 
1. Your IT Admin can either install a data gateway for your local SQL Server

2. You can get permissions to install a data gateway on your machine to act as a source for data

3. You can simply move the data from your local SQL Server to a developer/sandbox SQL db on a server/instance that your IT Admin has already set up the power bi gateway for. 

I would go with the third option for making life easier. 

Please give thumbs up if this helps. Thanks

[cha1234]

Hi, thank you.

I think what I am really asking is....how to give IT Admin the permission......

We have done it before, and gateways were successfully added, our IT Admin knew how to do it.

But with the recent change I just can't figure out how to give him the permission. Like, what to click? I tried [share], [direct access] none of them worked.

[dhruvinushah]

You need to explain your question a bit better then. Please add screenshots etc. 

[cha1234]

The title clearly said 'how to give PERMISSION to add gateway'

not 'how to add gateway'

[dhruvinushah]

https://community.powerbi.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447523#M6071...

[cha1234]

the helper above you already answered to the point, it's a fact that you misread the title so....

also, since you like to post link without any words

heres one for you https://www.oysterenglish.com/learn-how-read-english.html

Again, the other helper was able to CORRECTLY read my question, so i guess this is ur own fault?