Personal data gateway not showing up

[RoelVB]

I've installed the personal data gateway on two seperate PC's under two different users. Both show the same issue, where the gateway is not showing up in the web interface of Power BI.

On both systems the GatewayConfiguration log shows:

PersonalGatewayConfigurator.exe Information: 0 : Exception thrown during GetConfiguration: 'Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClientException: Error retrieving gateway configuration. ---> System.ServiceModel.EndpointNotFoundException: Er luistert geen eindpunt op net.pipe://localhost/powerbi/personalgatewayconfiguration/service dat het bericht kan accepteren. Dit wordt meestal veroorzaakt door een onjuist adres of een SOAP-actie. Zie InnerException, mits aanwezig, voor meer informatie.

Server stack trace: 
   bij System.ServiceModel.Channels.ConnectionUpgradeHelper.DecodeFramingFault(ClientFramingDecoder decoder, IConnection connection, Uri via, String contentType, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   bij System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   bij System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.CallOpenOnce.System.ServiceModel.Channels.ServiceChannel.ICallOnce.Call(ServiceChannel channel, TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
   bij System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   bij System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   bij System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   bij System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   bij Microsoft.PowerBI.DataMovement.Pipeline.InternalContracts.IGatewayConfigurationService.GetConfiguration()
   bij Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetConfiguration()
   --- Einde van intern uitzonderingsstackpad ---
   bij Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetConfiguration()
   bij Microsoft.PowerBI.DataMovement.GatewayCommon.ConfiguratorInitializationContextFactory.<GetConfiguratorStateAsync>d__0.MoveNext()'
PersonalGatewayConfigurator.exe Information: 0 : Exception thrown during GetConfiguration: 'Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClientException: Error retrieving gateway configuration. ---> System.ServiceModel.EndpointNotFoundException: Er luistert geen eindpunt op net.pipe://localhost/powerbi/personalgatewayconfiguration/service dat het bericht kan accepteren. Dit wordt meestal veroorzaakt door een onjuist adres of een SOAP-actie. Zie InnerException, mits aanwezig, voor meer informatie.

Server stack trace: 
   bij System.ServiceModel.Channels.ConnectionUpgradeHelper.DecodeFramingFault(ClientFramingDecoder decoder, IConnection connection, Uri via, String contentType, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   bij System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   bij System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.CallOpenOnce.System.ServiceModel.Channels.ServiceChannel.ICallOnce.Call(ServiceChannel channel, TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
   bij System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   bij System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   bij System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   bij System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   bij Microsoft.PowerBI.DataMovement.Pipeline.InternalContracts.IGatewayConfigurationService.GetConfiguration()
   bij Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetConfiguration()
   --- Einde van intern uitzonderingsstackpad ---
   bij Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetConfiguration()
   bij Microsoft.PowerBI.DataMovement.GatewayCommon.ConfiguratorInitializationContextFactory.<GetConfiguratorStateAsync>d__0.MoveNext()'
PersonalGatewayConfigurator.exe Information: 0 : Exception thrown during GetConfiguration: 'Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClientException: Error retrieving gateway configuration. ---> System.ServiceModel.EndpointNotFoundException: Er luistert geen eindpunt op net.pipe://localhost/powerbi/personalgatewayconfiguration/service dat het bericht kan accepteren. Dit wordt meestal veroorzaakt door een onjuist adres of een SOAP-actie. Zie InnerException, mits aanwezig, voor meer informatie.

Server stack trace: 
   bij System.ServiceModel.Channels.ConnectionUpgradeHelper.DecodeFramingFault(ClientFramingDecoder decoder, IConnection connection, Uri via, String contentType, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.SendPreamble(IConnection connection, ArraySegment`1 preamble, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.DuplexConnectionPoolHelper.AcceptPooledConnection(IConnection connection, TimeoutHelper& timeoutHelper)
   bij System.ServiceModel.Channels.ConnectionPoolHelper.EstablishConnection(TimeSpan timeout)
   bij System.ServiceModel.Channels.ClientFramingDuplexSessionChannel.OnOpen(TimeSpan timeout)
   bij System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.OnOpen(TimeSpan timeout)
   bij System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.CallOpenOnce.System.ServiceModel.Channels.ServiceChannel.ICallOnce.Call(ServiceChannel channel, TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.CallOnceManager.CallOnce(TimeSpan timeout, CallOnceManager cascade)
   bij System.ServiceModel.Channels.ServiceChannel.EnsureOpened(TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannel.Call(String action, Boolean oneway, ProxyOperationRuntime operation, Object[] ins, Object[] outs, TimeSpan timeout)
   bij System.ServiceModel.Channels.ServiceChannelProxy.InvokeService(IMethodCallMessage methodCall, ProxyOperationRuntime operation)
   bij System.ServiceModel.Channels.ServiceChannelProxy.Invoke(IMessage message)

Exception rethrown at [0]: 
   bij System.Runtime.Remoting.Proxies.RealProxy.HandleReturnMessage(IMessage reqMsg, IMessage retMsg)
   bij System.Runtime.Remoting.Proxies.RealProxy.PrivateInvoke(MessageData& msgData, Int32 type)
   bij Microsoft.PowerBI.DataMovement.Pipeline.InternalContracts.IGatewayConfigurationService.GetConfiguration()
   bij Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetConfiguration()
   --- Einde van intern uitzonderingsstackpad ---
   bij Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GetConfiguration()
   bij Microsoft.PowerBI.DataMovement.GatewayCommon.ConfiguratorInitializationContextFactory.<GetConfiguratorStateAsync>d__0.MoveNext()'

There's a piece of dutch in there that would translate to something like:

There is no endpoint listening on net.pipe://localhost/powerbi/personalgatewayconfiguration/service to accept the message. This is usually caused by an incorrect address for a SOAP-action.

[v-ljerr-msft · Accepted solution]

Hi @RoelVB,

Based on my research, you should be able to follow steps below to troubleshot this issue.

1. Try to force the gateway to communicate with Azure Service Bus using HTTPS instead of direct TCP. You will need to modify the Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config file. Change the value from AutoDetect to Https. This file is located, by default, at %localappdata%\Microsoft\on-premises data gateway (personal mode)\

<setting name="ServiceBusSystemConnectivityModeString" serializeAs="String">
    <value>Https</value>
</setting>

2. If you are using proxy, please verify if the proxy allows the connection. Here is the link to verify  https://powerbi.microsoft.com/en-us/documentation/powerbi-gateway-onprem/#ports

3.Please check to make sure you also whitelist the ip addresses for your data region in your firewall. You can download the Microsoft Azure Datacenter IP list here https://www.microsoft.com/en-us/download/details.aspx?id=41653 (PLEASE NOTE THIS LIST IS UPDATED WEEKLY)

In addition, here is also a similar thread on Issues forum for your reference. 

Regards

[RoelVB]

Thanks you. The first solution helped on one of the system. I'm going to try the other system on wednesday.