0 Kudos

Personal Gateways no longer working

Status: Needs Info
by FrugalEconomist Member on ‎10-18-2017 11:12 AM

Dear PowerBI Support,

 

None of my personal data gateways in powerbi pro are working now. I've noticed that this week it has happened.

These are two of the errors that I am seeing:

 

Activity ID: 935e9e44-5480-4c97-8218-766bc413f6d8
Request ID: c550e9ef-2201-aeb3-2212-3648bfd8bd1d
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net
Status code: 400
Error Code: DM_GWPipeline_Client_GatewayUnreachable
Time: Wed Oct 18 2017 11:09:08 GMT-0700 (Pacific Daylight Time)
Version: 13.0.2753.184

 

Activity ID: 935e9e44-5480-4c97-8218-766bc413f6d8
Request ID: bcb55f59-899f-6c1b-6847-b97039664dc3
Cluster URI: https://wabi-west-us-redirect.analysis.windows.net
Status code: 400
Error Code: DM_GWPipeline_Client_GatewayUnreachable
Time: Wed Oct 18 2017 11:10:59 GMT-0700 (Pacific Daylight Time)
Version: 13.0.2753.184

 

Status: Needs Info
Comments
by FrugalEconomist Member
on ‎10-18-2017 11:30 AM

 

 

Gateway is configured correctly, but is unreachable due to local network connectivity problems

 

Here is more details when I try to reinstall/update personal gateway:

Gateway service health check failed.

Below is the stack trace:
Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClientException: Error getting Gateway service health data. ---> System.ServiceModel.EndpointNotFoundException: There was no endpoint listening at net.pipe://localhost/powerbi/gatewayconfiguration/service that could accept the message. This is often caused by an incorrect address or SOAP action. See InnerException, if present, for more details. ---> System.IO.PipeException: The pipe endpoint 'net.pipe://localhost/powerbi/gatewayconfiguration/service' could not be found on your local machine.
--- End of inner exception stack trace ---

Server stack trace:
at System.ServiceModel.Channels.PipeConnectionInitiator.GetPipeName(Uri uri, IPipeTransportFactorySettings transportFactorySettings)
at System.ServiceModel.Channels.NamedPipeConnectionPoolRegistry.NamedPipeConnectionPool.GetPoolKey(EndpointAddress address, Uri via)
at System.ServiceModel.Channels.CommunicationPool`2.TakeConnection(EndpointAddress address, Uri via, TimeSpan timeout, TKey& key)
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.InternalContracts.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()

by v-haibl-msft Super Contributor
on ‎10-19-2017 08:17 PM

@FrugalEconomist

 

Could you please 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>

 

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

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)

 

Best Regards,
Herbert

by Vicky_Song Established Member
on ‎10-19-2017 08:19 PM
Status changed to: Needs Info
 
by FrugalEconomist Member
on ‎10-24-2017 09:59 AM

Hello,

I've checked the config file settings and they are set to HTTPS.

But I think my issue is not with the personal one but the enterprise gateway.

None of my direct queries work now becuase the gateway won't connect.

by FrugalEconomist Member
on ‎10-24-2017 10:07 AM

Error generating an asymmetric key.

The communication object, System.ServiceModel.Channels.ServiceChannel, cannot be used for communication because it is in the Faulted state.

Server stack trace:
at System.ServiceModel.Channels.CommunicationObject.ThrowIfDisposedOrNotOpen()
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.InternalContracts.IGatewayConfigurationService.GenerateAsymmetricKey()
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.GenerateAsymmetricKey()