Forum Discussion
On-Premises data gateway problem: Re-Install every time it closes
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?
- Greg_Deckler2 years agoCommunity Champion
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.
- Anonymous2 years agoNot applicable
Yes! I have it like this already:
- Greg_Deckler2 years agoCommunity Champion
Anonymous OK, with your confirmation that the service is running, do you still get the error when opening the gateway app? If so, you are going to need to export the logs and potentially engage support as to what is going on. Troubleshoot the on-premises data gateway | Microsoft Learn