Forum Discussion

lloetters's avatar
lloetters
Icon for Advocate II rankAdvocate II
10 years ago
Solved

Firewall Power BI Enterprise Gateway

Hi,

 

We have a customer, who liked to use the Power BI Enterprsie Gateway. The customer has an firewall installed that blocks all incoming traffic. We found a list with ports https://powerbi.microsoft.com/de-de/documentation/powerbi-gateway-enterprise/#ports here. The problem is the Firewall and Proxy can only pass Ip Adress no DNS adresses like

*.powerbi.com443HTTPS

 

Does anybody knows the full IP-Adresses for alle these Microsoft Services ? For your Customer it is very urgent. Thanks a lot.

 

*.powerbi.com443HTTPS
*.analysis.windows.net443HTTPS
*.login.windows.net443HTTPS
*.servicebus.windows.net5671-5672Advanced Message Queuing Protocol (AMQP)
*.servicebus.windows.net443, 9350-9354Listeners on Service Bus Relay over TCP (requires 443 for Access Control token acquisition)
*.frontend.clouddatahub.net443HTTPS
**.core.windows.net443HTTPS
login.microsoftonline.com443HTTPS
login.windows.net443HTTPS

 

 

Kind regards

Lukas

Need Help

12 Replies

  • GuyInACube's avatar
    GuyInACube
    Icon for Administrator rankAdministrator
    10 years ago

    These are outbound connections. Not inbound. Is outbound traffic on those items being blocked?

    • Nitron's avatar
      Nitron
      New Member
      10 years ago

      Yes, outgoing communication to non standard-ports is being blocked

      (standard 443) should be working

      (non standard 5671-5672 and 9350-9354) is not working and agreed from firewall team that these ports a being blocked and target IPs are needed

  • elserafi's avatar
    elserafi
    Regular Visitor
    9 years ago

    Dear All,

     

    I have the same problem. My customer wants to add the IP ranges for PowerBI online services to be part of the exceptions to use the Data Gateway installed on their DMZ server to access PowerBI. Kindly advise if this is possible.

     

    Thanks,

    Mahmoud

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hello,

     

    I know this thread is a bit old but I am facing the same issue with on-premise enterprise gateway and corporate firewall.

     

    The tool fails to create/configure a gateway. I was able to extract these exceptions from the configurator logs. Your help is highly appreciated!

     

    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.