On Premises Data Gateway on a dataflow (cant access the Gateway)

[DebbieE]

I currently have an issue working with other developers on a dataflow.

Im quite new on the project. The other developer on the project created a dataflow against an on premesis database. When they set up the connection they had automatic access to the On Premesis data Gateway. so they used that and connected with the database credentials all OK

I then took ownership of the workflow because I want to work on them. However when I go into power Query Editor on the Service I get this

I dont have a Gateway to connect to, whereas the other developers have a gateway in their List. this means that i know the company has a data gateway and I would like to use it.

I dont normally deal with On premesis data. Any tips with what I need to do would be great, either in Service or on the On Premesis Gateway myself.

[Anonymous]

Hi @DebbieE ,

Due to your data source is from on-premises, it requires to have a data gateway setup. And dataflow only support using Enterprise Gateway, and the user should be the administrator of gateway. You can refer the following documentations for more details.

Using dataflows with on-premises data sources

Getting Started With Dataflow in Power BI

Best Regards

Rena

[DebbieE]

"Due to your data source is from on-premises, it requires to have a data gateway setup. And dataflow only support using Enterprise Gateway, and the user should be the administrator of gateway. You can refer the following documentations for more details."

They do have and Enterprise Gateway set up though because other developers get access to the Gateway for the Dataflow. 

Are you saying that to use the Gateway you must be an administrator? I dont know if they are going to go for that?

[Anonymous]

Hi @DebbieE ,

Please try to request the owner of gateway to add you as gateway administrator, then check if you can find and choose the corresponding gateway in on-premises data gateway(see the part in red circle). You can refer this documentation about how to add the user as gateway administor. 

Best Regards

Rena

[DebbieE]

I wont be able to be an Administrator in this case. Surely you just need to be added as a user of the specific data source?

[nandukrishnavs · Accepted solution]

@DebbieE 

The admin has to add you as a user of that particular source.

https://docs.microsoft.com/en-us/power-bi/connect-data/service-gateway-data-sources#add-users-to-a-d...

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 🙂