Forum Discussion

Rinaldi's avatar
Rinaldi
Regular Visitor
5 years ago
Solved

Powerbi Gateway IP and Port Configuration

Hi.   I have a PowerBI Gateway server configured for the ip / domain destination based on this link https://docs.microsoft.com/en-us/data-integration/gateway/service-gateway-communication#ports. Wh...
Need Help
  • RakeshSinghr's avatar
    RakeshSinghr
    5 years ago

    ip addresses for azure data centers are constantly changed. You'll need exception rules or whitlist FQDN's.

    Get your network team to run wire shark and see where the packet is being blocked.

    Perform network test inside of the gateway app to see if you get any more info

RakeshSinghr's avatar
RakeshSinghr
Icon for Resolver I rankResolver I
5 years ago

If its working atleast once that means the connection has been established and no other ports to be opened.

 

I'd look at your proxy server to see if incoming request is being blocked during the failure time.

Also, enable verbose logging and check the errors logs.

 

Track the time it takes to error out, for example erroring out immediately when refresh starts versus consistent error out time for example say after 1 min or so to discount internet speed/network bandwidth issues

  • Rinaldi's avatar
    Rinaldi
    Regular Visitor
    5 years ago

    Hi Rakesh Singh r,

     

    Enable verbose logging you mean is "additional logging" at powerbi gateway application"?

    And how can you see our proxy server?

     

    But based on my previous question, because our network IT team limit the network, which IP destinations can I open? because since the gateway application is used on the server, there is a limited role by our network team.

     

    Thanks.

    • RakeshSinghr's avatar
      RakeshSinghr
      Icon for Resolver I rankResolver I
      5 years ago

      ip addresses for azure data centers are constantly changed. You'll need exception rules or whitlist FQDN's.

      Get your network team to run wire shark and see where the packet is being blocked.

      Perform network test inside of the gateway app to see if you get any more info

      • Rinaldi's avatar
        Rinaldi
        Regular Visitor
        5 years ago

        Hi.

         

        Thanks to RakeshSinghr. That's good solution. 

         

        I'm discussing this to the network team.

         

        But my last question. "need exception rule" you mean is open all the ip destination right? or create FQDN's whitlist. And about FQDN's whitlist, can I download the list IP from this link https://www.microsoft.com/download/details.aspx?id=41653? or just run wire shark to check where the packet is being blocked and check network ports test. Just to make sure it.

         

        Thanks.