unable to install PowerBI data gateway ?

[AnandRanga]

I am trying to configure schedule refresh but for that I need to install PowerBI data gateway. I want to install it on my system(local).

I am clicking on install now and I am getting this:

but then Opened this link  : https://powerbi.microsoft.com/en-us/gateway/ 

and clicked on download gateway and installed on my system. Installation was succesful but It's giving me this error:

Your data gateway (Power BI – personal) is offline or couldn't be reached.
Please try again later or contact support. If you contact support, please provide these details.

Processing errorYour data gateway (Power BI – personal) is offline or could not be reached. Ensure the gateway computer is on and you are logged on to it during the scheduled refresh period.

What to do? Any solution?

 Thanks.

[PavelR]

Hi @AnandRanga, have you searched there? https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem-tshoot/

Regards.

Pavel

[ankitpatira]

@AnandRanga After installing gateway did you signed in ? If not you need to open up gateway app on the machine it is installed and sign it. After that you should be able to see it online via power bi service.

[AnandRanga]

@ankitpatira

Yes i have logged in,even i am getting this screen also

[ankitpatira]

@AnandRanga From the screenshot, you've installed on-premise gateway but error you've posted in original post is about personal gateway. On-premise gateway and personal gateway are two different options and so you should be looking for on-premise gateway in power bi service.

[AnandRanga]

@ankitpatira

My database from where I am fetching the data is not on my local machine, It's on a database server somewhere so What should I install on-premise or personal gateway and should I install it on my local machine or on server ?

I am downloading the gateway from this link:

https://powerbi.microsoft.com/en-us/gateway/

 and It installs On-premise data gateway installer, when it asks to choose between on-premise and personal, I choose on-premise(recommended) and It get installed on my c: drive programfiles. After that It asks me to Sign in to register my gateway and I sign in successfully. After that It gives me two option 1) Register a new gateway or 2) migrate or restore an existing, I choose new and enter the date gateway name and recovery key when asked and click on configure and it shows this screen:

I click on close and it's gone. But It says that for PowerBI, you need to add your data sources to this  gateway. How to do that?

One more thing is that I am stiil getting this screen when I click on schedulre refresh for that Dataset:

What's the problem here, after successfull installation of Data gateway why I am getting this screen again, Why it's not going to the next step itself, can't It detect itself that data gateway is installed now? Am I going in right direction?

Need help, Thanks.

[ankitpatira]

@AnandRanga You should install on-premise gateway which is what you've got so that is correct. Once gateway is installed and you've signed in, next step is to login to power bi service -> on top right hand side click settings icon (wheel) -> click Manage gateways -> Add data sources. This is where you should add your data source ie connection to your database. Once that done then publish report from power bi desktop to power bi service and it should work. Make sure connection details you've added under Add data source for gateway are same as used by your report in power bi desktop ie if you've used ip address then use ip address in report, if alias name in gateway then same in the report.

[PavelR · Accepted solution]

Hi @AnandRanga. Have you configured "Manage gateway" and added all appropriate Data sources, with correct credentials?

Mostly "the screen" (your picture n.2) is because of the fact, that you didnť add all the datasources and their credentials.

Regards.

Pavel