Forum Discussion
On-Premises data gateway problem: Re-Install every time it closes
Hey guys! How are you?
I am facing some issues using my On-Premises Data Gateway. I have configured it and works fine, but everytime I close it, I need to install the gateway again in order to be working fine.
For example, if I reboot my computer or I turn it off and on, I must unninstall the gateway and then install it again (configuring it with the same account). If I do not unninstall it and re-install it, my power bi refreshes fail saying: "Gateway Unreacheable".
Is there a way to solve this without unninstalling and installing it again everytime I turn on my pc?
10 Replies
Anonymous Sounds like you are running personal mode perhaps. You don't need to uninstall and reinstall. You simply need to search for and run the "on-premises data gateway" app and login.
I am sorry. Now I have reboot my laptop and when I open the gateway I get this first:
1.
2. Then this:
3. And when I retry:
The full error for the "Gateway service health check failed." is:
Below is the stack trace:
Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClientException: Error getting Gateway service health data.
Exception message: Could not connect to net.tcp://127.0.0.1:45375/powerbi/gatewayconfiguration/service. The connection attempt lasted for a time span of 00:00:02.0235257. TCP error code 10061: No connection could be made because the target machine actively refused it 127.0.0.1:45375. ---> System.ServiceModel.EndpointNotFoundException: Could not connect to net.tcp://127.0.0.1:45375/powerbi/gatewayconfiguration/service. The connection attempt lasted for a time span of 00:00:02.0235257. TCP error code 10061: No connection could be made because the target machine actively refused it 127.0.0.1:45375. ---> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 127.0.0.1:45375
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.Sockets.Socket.Connect(EndPoint remoteEP)
at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
--- End of inner exception stack trace ---Server stack trace:
at System.ServiceModel.Channels.SocketConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
at System.ServiceModel.Channels.BufferedConnectionInitiator.Connect(Uri uri, TimeSpan timeout)
at System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
at System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.CallOpenOnce.System.ServiceModel.Channels.ServiceChannel.ICallOnce.Call(ServiceChannel channel, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
at System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
at System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
at System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)Exception rethrown at [0]:
at System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
at System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
at Microsoft.PowerBI.DataMovement.Pipeline.ConfigurationContracts.IGatewayConfigurationService.GetServiceHealth()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetServiceHealth()
--- End of inner exception stack trace ---
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetServiceHealth()
at Microsoft.PowerBI.DataMovement.GatewayCommon.Checks.GatewayServiceCheck.RunCheck()Im sorry, this is the reason why I have to unninstall and install everyday. Do you know how to solve this?
Anonymous OK, you are running the standard version of the gateway then that installs as a service. In that case, open up Services and scroll down to "On-premises data gateway service". Make sure that it is set to a Startup Type of Automatic and the logon should be set to NT SERVICE\PBIEgwService.
Hi Anonymous
Thanks for the solutions Anonymous and Greg_Deckler provided, you can check the problems from the gateway log. you can refer to the following link.
Best Regards!
Yolo Zhu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
