Power BI Gateway Installation failure

[tonyzhang]

 Hello I tried mulitiple attempts to get the gateway installed on my machine but failed.  the following is the description of the error:

"The on-premises data gateway (personal mode) installer failed to download.
No connection could be made because the target machine actively refused it 23.218.34.222:443"

 Can you please help and advise a solution? thanks,

[v-yuezhe-msft]

@tonyzhang,

In your scenario, please ensure that you use admin account to install gateway. And make sure you add required ports in the firewall if the firewall is on.

If the issue still persists, please share gateway installer log which is located at C:\Users\yourusername\AppData\Local\Temp\On-premises_data_gateway_(personal_mode)_*.log.

Regards,
Lydia

[tonyzhang]

[tonyzhang]

@v-yuezhe-msft Hi Lydia, Eventally I got the Gateway installed; however, I encountered some issues when I was registering the gateway.

Issue 1: Failed to update gateway details. You may need to change the account the gateway runs under.

Details:

"Failed to update gateway details. You may need to change the account the gateway runs under.

Error updating gateway configuration.

Server stack trace:
at System.ServiceModel.Channels.ServiceChannel.ThrowIfFaultUnderstood(Message reply, MessageFault fault, String action, MessageVersion version, FaultConverter faultConverter)
at System.ServiceModel.Channels.ServiceChannel.HandleReply(ProxyOperationRuntime operation, ProxyRpc& rpc)
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.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request, Int32 maxRetries)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayClient.GatewayConfigurationClient.UpdateGatewayConfiguration(UpdateGatewayConfigurationRequest request, Int32 maxRetries)An ExceptionDetail, likely created by IncludeExceptionDetailInFaults=true, whose value is:
Microsoft.PowerBI.DataMovement.Pipeline.Diagnostics.CouldNotUpdateGatewayConfigurationException: Error updating gateway configuration. ----> System.ServiceModel.CommunicationException: Unable to reach wabi-us-east2-relay25.servicebus.windows.net HTTP (80, 443) ----> System.AggregateException: One or more errors occurred. ----> System.ServiceModel.CommunicationException: Unable to connect to factory endpoint. ----> System.Net.WebException: Unable to connect to the remote server ----> System.Net.Sockets.SocketException: No connection could be made because the target machine actively refused it 104.46.98.9:80
at System.Net.Sockets.Socket.DoConnect(EndPoint endPointSnapshot, SocketAddress socketAddress)
at System.Net.ServicePoint.ConnectSocketInternal(Boolean connectFailure, Socket s4, Socket s6, Socket& socket, IPAddress& address, ConnectSocketState state, IAsyncResult asyncResult, Exception& exception)
--- End of inner ExceptionDetail stack trace ---
at System.Net.HttpWebRequest.GetRequestStream(TransportContext& context)
at System.Net.HttpWebRequest.GetRequestStream()
at Microsoft.ServiceBus.WebStream.CreateSession(Uri& endpointLocation1, Uri& endpointLocation2)
--- End of inner ExceptionDetail stack trace ---
at Microsoft.ServiceBus.WebStream.CreateSession(Uri& endpointLocation1, Uri& endpointLocation2)
at Microsoft.ServiceBus.WebStream.Connect()
at Microsoft.ServiceBus.WebStream.IsSupportingScheme(Uri factoryEndpointUri, Exception& exception)
--- End of inner ExceptionDetail stack trace ---

--- End of inner ExceptionDetail stack trace ---
at Microsoft.ServiceBus.NetworkDetector.DetectInternalConnectivityModeForHttp(Uri uri)
at Microsoft.ServiceBus.ConnectivityModeHelper.GetInternalConnectivityMode(ConnectivitySettings connectivitySettings, HttpConnectivitySettings httpConnectivitySettings, Uri uri)
at Microsoft.ServiceBus.ConnectivityModeConnectionElement..ctor(TokenProvider tokenProvider, SocketSecurityRole socketSecurityMode, BindingContext context, NameSettings nameSettings, ConnectivitySettings connectivitySettings, HttpConnectivitySettings httpConnectivitySettings, Nullable`1 sslProtocolOverride)
at Microsoft.ServiceBus.TcpRelayTransportBindingElement.BuildInnerBindingElement(BindingContext context)
at Microsoft.ServiceBus.TcpRelayTransportBindingElement.BuildChannelListener[TChannel](BindingContext context)
at System.ServiceModel.Channels.Binding.BuildChannelListener[TChannel](Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, BindingParameterCollection parameters)
at System.ServiceModel.Description.DispatcherBuilder.MaybeCreateListener(Boolean actuallyCreate, Type[] supportedChannels, Binding binding, BindingParameterCollection parameters, Uri listenUriBaseAddress, String listenUriRelativeAddress, ListenUriMode listenUriMode, ServiceThrottle throttle, IChannelListener& result, Boolean supportContextSession)
at System.ServiceModel.Description.DispatcherBuilder.BuildChannelListener(StuffPerListenUriInfo stuff, ServiceHostBase serviceHost, Uri listenUri, ListenUriMode listenUriMode, Boolean supportContextSession, IChannelListener& result)
at System.ServiceModel.Description.DispatcherBuilder.InitializeServiceHost(ServiceDescription description, ServiceHostBase serviceHost)
at System.ServiceModel.ServiceHostBase.InitializeRuntime()
at System.ServiceModel.ServiceHostBase.OnBeginOpen(TimeSpan timeout, AsyncCallback callback, Object state)
at System.ServiceModel.Channels.CommunicationObject.OpenAsyncResult.InvokeOpen()
at System.ServiceModel.Channels.CommunicationObject.OpenAsyncResult..ctor(CommunicationObject communicationObject, TimeSpan timeout, AsyncCallback callback, Object state)
at System.ServiceModel.Channels.CommunicationObject.BeginOpen(TimeSpan timeout, AsyncCallback callback, Object state)
at System.Threading.Tasks.TaskFactory`1.FromAsyncImpl[TArg1](Func`4 beginMethod, Func`2 endFunction, Action`1 endAction, TArg1 arg1, Object state, TaskCreationOptions creationOptions)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<ExecuteRunnerIterationAsync>d__15.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.<StartRunnerAsync>d__14.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.ServiceModel.ServiceHostController.StopHandle.<StartRunnerAsync>d__3.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayServiceHost.GatewayServiceHost.<UpdateConfigurationImpl>d__24.MoveNext()
--- End of inner ExceptionDetail stack trace ---
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayServiceHost.GatewayServiceHost.<UpdateConfigurationImpl>d__24.MoveNext()
--- End of stack trace from previous location where exception was thrown ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at Microsoft.PowerBI.DataMovement.Pipeline.Common.TaskUtils.ExtendedWait(Task task, TimeSpan timeout)
at Microsoft.PowerBI.DataMovement.Pipeline.GatewayServiceHost.GatewayServiceHost.UpdateConfiguration(GatewayConfiguration configuration, Int32 maxRetries)
at Microsoft.PowerBI.DataMovement.Pipeline.Common.Diagnostics.PipelineTelemetryService.ExecuteInActivity(PipelineActivityType pipelineActivityType, Action action)
at SyncInvokeUpdateGatewayConfiguration(Object , Object[] , Object[] )
at System.ServiceModel.Dispatcher.SyncMethodInvoker.Invoke(Object instance, Object[] inputs, Object[]& outputs)
at System.ServiceModel.Dispatcher.DispatchOperationRuntime.InvokeBegin(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.ImmutableDispatchRuntime.ProcessMessage5(MessageRpc& rpc)
at System.ServiceModel.Dispatcher.MessageRpc.Process(Boolean isOperationContextSet)"

Issue 2:Gateway service health check failed because of timeout.

Below is the stack trace:
Health check failed because it cannot finish in 2000 ms.

I'm a Power BI Pro user now. I will appreciate it very much if you can give me a clue on how to fix the issues.

thanks,

[v-yuezhe-msft]

@tonyzhang,

"Unable to reach wabi-us-east2-relay25.servicebus.windows.net HTTP (80, 443) "

Please follow the guide in this article to test connectivity to the Azure Service Bus.  Also ensure that you have added required ports(80,443,etc) into your firewall rule.

Regards,
Lydia