cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
bhushangawale
Frequent Visitor

Auto sign in to on-premise data gateway

Hi, 

 

 

We have installed the Power BI data gateway closely to our database on one of the Azure VM and works fine, however everytime the VM is restarted it sings out the gateway logged in account and gateway is shown as not available or offline untill we sign in again. We have ensure that we have installed the gateway in non-personal mode. 

 

Currently, it is quite annoying to keep on checking for availability and VM status, Is there any way to avoid the re-login step everytime the machine is restarted to bring gateway online? Or would there be any way to auto-sign in to the gaetway (startp script?) whenever the machine is restarted?

 

Thanks in advance.

1 ACCEPTED SOLUTION

All right after several workarounds, realized that there is no need to auto-sign to the gateway whenever your host machine gets restarted why?

Why is because - the on premises data gateway in the background runs as a service however you might want to set it's start up type as automatic so that it gets started whenever your machine is restared. Please note that the gateway UI will keep on showing you that you need to sign in again but you can ignore that because the service already knows how to get going with the service account. 

View solution in original post

10 REPLIES 10
CmdrKeene
Helper IV
Helper IV

I'm looking for a solution here too.  We have about 10 users of PowerBI but I'm the only one that creates datasets, and the gateway runs on my machine. But every time my machine restarts, the PowerBI service stops refreshing because my gateway cannot be reached. Once I've logged-into that machine again, the refresh begins working.


CmdrKeene
rohit_acharya
Frequent Visitor

Like @bhushangawale mentioned there is no need to sign in whenever server restarts. After several rounds of debugging we were able to troubleshoot. In any given server there can only be one gateway running, whenever a new gateway instance is installed the older one automatically signs-off. There is no support for parallel gateways to be running on a server. This caused our gateway to log off all the time. 

BG50
Regular Visitor

Same issue here. It seems there was some change either on our server with Power BI in the last few months. We are running On-Premis Gateway in personal mode. When ever the server is restarted the gateway disconnects and I have to login to the Gateway before it reconnects. I have only found community documents that say that this does not happen. Anyone else find that this does happen still and any workarounds? I am using personal mode so I am thinking perhaps going to the non-personal mode might do something different. The personal mode seems fine as I am the  only one who uses Power BI. Any help or even tips for what to reserch would be much appreciated. Thanks in advance!

v-yuezhe-msft
Microsoft
Microsoft

@bhushangawale,

It is not possible to use script to auto-sign in to gateway whenever the machine is started. I have made a test, the on-premises gateway is still online and schedule refresh isn't impacted each time we restart gateway machine.

Regards,
Lydia

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

@v-yuezhe-msft Thanks for your response, glad to know that your test worked. Can you point if I have missed anything while installing or configuring the gateway on our Azure VM? It still gets logged out and shown as disconnected everytime the VM is restarted.

Any update on this please? Gateway login still keeps on logging out whenever the host virtual machine is restarted.

All right after several workarounds, realized that there is no need to auto-sign to the gateway whenever your host machine gets restarted why?

Why is because - the on premises data gateway in the background runs as a service however you might want to set it's start up type as automatic so that it gets started whenever your machine is restared. Please note that the gateway UI will keep on showing you that you need to sign in again but you can ignore that because the service already knows how to get going with the service account. 

View solution in original post

This is not true with our set up. Server 2016 when ever restarted we have to sign back into on-premisis gateway. Thx.

@bhushangawale  I too have the same annoying problem of gateway switching off everytime the host restarts and this points to me logging in everytime it restarts. any idea how we can how to set its startup type as automatic?

Anonymous
Not applicable

Anyone found the solution to this problem.  I will also prefer not to be using my personal work email address to set this up in the event someone else has to take ownership of the reports.

Helpful resources

Announcements
Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

User Group Leader Meeting January 768x460.png

Calling all User Group Leaders!

Don't miss the User Group Leader meetings on January, 24th & 25th, 2022.

Jan 2022 Dev Camp 768x460 copy.png

Power BI Dev Camp- January 27th, 2022

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors