On Premises Data Gateway

[Anonymous]

Hi Team,

We are encountering an error with the PowerBI gateway setup on our server, every time the server resizes or restarts PowerBI Gateway is not restarting automatically, even though the Gateway was set to start Automatically in Services, also we are not able to see anything in the log file of the gateway as well. Could you please suggest us a solution for this to get resolved.

We are getting an error messsage as shown below and once we click on Retry the On-Premises data gateway is getting started, but the problem for us is that, this can't keep happening.

Regards,

Ashwin Vasudevan

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please try switching Startup Type from "Automatic" to "Automatic  (Delayed Start)" then test again. 

If issue persists, please provide event viewer logs and gw logs. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Anonymous,

Glad to hear the issue is resolved. I will close this thread as you requested. 

Best Regards,
Qiuyun Yu 

[brynjellis]

Sorry guys, what was the resolution to this please?  Delayed Start hasn't fixed this for me!  Was there something else you did but isn't posted here?

[Anonymous]

Hi,

Apart from delayed start. there was something else we did for this.

You might need to increase the start up time of the application (PowerBI) on the server. As the server starts, for us it was trying to start the powerBI application within a certain amount of seconds, but PowerBI was not able to start in the given time period, so it was failing. If you could increase the Start Up time of the PowerBI application on the server, this would resolve your issue.

Regards,

Ashwin 

[brynjellis]

Thanks for quick reply Ashwin.  When you say "You might need to increase the start up time of the application (PowerBI) on the server" do you mean the On-Premesis Power BI Gateway windows service?

If so, I've increased that to 60000 milliseconds which is double the default and it didn't help.  Should I increase it even more?  Or are you speaking about something else?

[Anonymous]

No Problem, I am exactly talking about it. Can you please increase it to 240,000 milliseconds. We increased it gradually from 60,000 to 300,000 milli seconds and what we found was the application is taking atleast 3 minutes to start. This is confined with the server capacity. If you could gradually increase the time out, this should resolve your issue.

Regards,

Ashwin

[Anonymous · Accepted solution]

Hi Qiuyun Yu,

we have resolved this. Could you please close/resolve this ticket.

Regards,

Ashwin

[Anonymous]

Hi Qiuyun Yu,

Thank you so much for the idea. We will follow this and will let you know if the issue still persists.

Regards,

Ashwin Vasudevan

[v-qiuyu-msft · Accepted solution]

Hi @Anonymous,

Please try switching Startup Type from "Automatic" to "Automatic  (Delayed Start)" then test again. 

If issue persists, please provide event viewer logs and gw logs. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @Anonymous,

I have reported this issue internally: CRI 90170508. Will update here once I get any information. 

Best Regards,
Qiuyun Yu 

[Anonymous]

Hi Team,

Just to add more info on this to get a better idea.

Gateway version number 3000.0.143.1 (October 2018)

Windows Edition is  Windows Server 2016 Datacenter

Regards,

Ashwin