Cannot access Power BI Gateway behind firewall

[Anonymous]

Hello,

We followed the guide on https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication#ports to open ports to allow Power BI access to the on-premise data gateway. Still after applying these rules, Power BI Service fails to connect to the gateway. When we allow all traffic, everything works but this is cannot be the solution.

Kindly inform if there is a missing domain/port that we need to add to the rules.

[v-chuncz-msft]

@Anonymous 

You may take a look at Troubleshoot the on-premises data gateway.

[youssefyoussef]

I tried but nothing worked. I tried the diagnostics tests and it fails to connect to network.

[youssefyoussef]

I tried to uninstall and reinstall the gateway. When reinstalling I get the below error:

The on-premises data gateway installer failed to download.
An existing connection was forcibly closed by the remote host

[Anonymous]

Hello

Any help here. I was able to install the gateway using the offline installer but it fails to create the gateway. Here is the error I found in the gateway configurator logs.

---

EnterpriseGatewayConfigurator.exe Information: 0 : backendUriFromService: https://wabi-north-europe-redirect.analysis.windows.net/
EnterpriseGatewayConfigurator.exe Warning: 0 : DiscoverUnifiedGateway returned exception: System.AggregateException: One or more errors occurred. ---> System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at System.Net.Security._SslStream.EndRead(IAsyncResult asyncResult)
at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.Http.HttpClientHandler.GetResponseCallback(IAsyncResult ar)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<GetUnifiedGatewayClustersRequireAdminAsync>d__40.MoveNext()
--- End of inner exception stack trace ---
at System.Threading.Tasks.Task`1.GetResultCore(Boolean waitCompletionNotification)
at Microsoft.PowerBI.DataMovement.GatewayUiCommon.WizardViewModelBase.GetGatewayCollection(HttpClient gatewayHttpClient)
---> (Inner Exception #0) System.Net.Http.HttpRequestException: An error occurred while sending the request. ---> System.Net.WebException: The underlying connection was closed: An unexpected error occurred on a receive. ---> System.IO.IOException: Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. ---> System.Net.Sockets.SocketException: An existing connection was forcibly closed by the remote host
at System.Net.Sockets.Socket.EndReceive(IAsyncResult asyncResult)
at System.Net.Sockets.NetworkStream.EndRead(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at System.Net.Security._SslStream.EndRead(IAsyncResult asyncResult)
at System.Net.TlsStream.EndRead(IAsyncResult asyncResult)
at System.Net.Connection.ReadCallback(IAsyncResult asyncResult)
--- End of inner exception stack trace ---
at System.Net.HttpWebRequest.EndGetResponse(IAsyncResult asyncResult)
at System.Net.Http.HttpClientHandler.GetResponseCallback(IAsyncResult ar)
--- End of inner exception stack trace ---
at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
at Microsoft.PowerBI.DataMovement.ExternalClient.PowerBIDataMovementClientExtensions.<GetUnifiedGatewayClustersRequireAdminAsync>d__40.MoveNext()<---

EnterpriseGatewayConfigurator.exe Information: 0 : Model gateway state: Unconfigured

[Anonymous]

@v-chuncz-msft Would you please check this issue?

I changed the proxy settings of the gateway to sniff all the traffic and these are the requests that failed. I used Fiddler to intercept the traffic.

GET https://wabi-north-europe-redirect.analysis.windows.net/unifiedgateway/gatewayclusters HTTP/1.1
Authorization: Bearer .....
Host: wabi-north-europe-redirect.analysis.windows.net

PUT https://wabi-north-europe-redirect.analysis.windows.net/unifiedgateway/gateways/CreateGatewayWithApps HTTP/1.1
Authorization: Bearer .....
Content-Type: application/json; charset=utf-8
Host: wabi-north-europe-redirect.analysis.windows.net
Content-Length: 1227
Expect: 100-continue

{"createGatewayRequest":{"gatewayName":"Syngenta Genomic Selection","gatewayDescription":null,"gatewayAnnotation":"{\"gatewayContactInformation\":[\"youssef.youssef@syngenta.com\"],\"gatewayVersion\":\"3000.9.194+ga90bb05c0e\",\"gatewayWitnessString\":\"{\\\"EncryptedResult\\\":\\\"F1OdSMaoZWVAzIHn8m9nv3VE3zPdH1GYBvJWTtoZ7aVerACimZAqYBFBiteu/NX1sKEkKgJcCvdv9KfcKRzfGQjBPR+JfVbXbBZeVrK19+Ia8jLPk4M64Y3gbi1OnReib2Kt+xrMPMkc8XWMbpfrwQ==\\\",\\\"IV\\\":\\\"ZW4OYXp102Ts8YFlmCktFQ==\\\",\\\"Signature\\\":\\\"mjRnocRFLo+XShddSLY22LmxhUh9eXhlkb6mPtEBp8Q=\\\"}\",\"gatewayMachine\":\"USAEIWPBID001\"}","gatewayPublicKey":"PD94bWwgdmVyc2lvbj0iMS4wIj8+DQo8UlNBUGFyYW1ldGVycyB4bWxuczp4c2Q9Imh0dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hIiB4bWxuczp4c2k9Imh0dHA6Ly93d3cudzMub3JnLzIwMDEvWE1MU2NoZW1hLWluc3RhbmNlIj4NCiAgPEV4cG9uZW50PkFRQUI8L0V4cG9uZW50Pg0KICA8TW9kdWx1cz5wMWJqVnJZVyszK3hzUmYzUmNRclBWTk5OUktTYkU3ZDAreGtoWFdpNmh5TTVFL0k5emdBRVVUeXNBeVhBbXU4V0txMmRWNW1DMUsrWlFNYVR2SDEyL3FaeDVMWWRDNUQ1OElGWkE0cTdIY2cwcVRjYStQeGVaYm1JZnpZWnQvZjRWYTBjNHBxVE5IQTdlMDNMdTFWTWkvVUM0NkloeXAyMW8zWk9KNmNiWWs9PC9Nb2R1bHVzPg0KPC9SU0FQYXJhbWV0ZXJzPg=="},"appsToAdd":["PowerBI","PowerApps","LogicApps","PowerBIPaaS","AsAzure","PowerPlatformAdminCenter"]}