Complete IP range to whitelist for On Premise Power BI Data Gateway installation

[zhwu]

My company's firewall settings do not allow mask in the whitelist   (so  'www.powerbi.com' will work  but  '*.powerbi.com'  won't work);  therefore we decieded to whitelist IP addresses instead.      Our network team has whitelisted all the Microsoft Azure DataCenter IP list for the Power BI Data Gateway server according to information from this article: https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem

However,  We notice this Azure Data Center IP list does not contain some of the IPs needed for  PowerBI data gateway installation.  For example:  www.powerbi.com appears to have an IP address outside this IP list for Azure data Center,   Even after we downloaded the Power BI setup file 'PowerBIGatewayInstaller.exe'  (from another machine) and try to run it on the server,  it  tries to  connect  to some URL outside the IP whitelist.    (the setup process tries to connect to:   go.microsoft.com)

Is there a complete list of all the IPs  (or full URL)  we need to whitelist  (on port 80 & 443) for the Power BI Data Gateway server setup?     We have no idea what other sites PowerBIGatewayInstaller.exe needs to connect during the setup process. 

[v-yulgu-msft]

Hi @zhwu,

As the Azure IP range list is updated weekly. You will need to monitor the list and make appropriate changes. 

Please have a look at below links:

Whitelist the Azure IP range

Mass IP Whitelisting for Azure Datacenter

Regards,

Yuliana Gu

[Greg_Deckler]

Check this out:

https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem-indepth#forcing-https-communication...

Then have a look at this:

https://blogs.msdn.microsoft.com/servicebus/2017/11/07/open-port-requirements-and-ip-address-whiteli...

[zhwu]

We are having problem installing Power BI Data Gateway on the server.     It appears Microsoft setup file:  PowerBIGatewayInstaller.exe   needs to connect to some IPs (URLs)  outside their  Azure DataCenter IP List as part of the setup process.    (For example:  it wants to connect to  go.microsoft.com and we are not sure if there any other URL it will need ) 

Our network team is asking us to provide them the IP list (or full URL)  they need to whitelist.  Since I have no idea what other URLs the  Installer may need  (and I can't give them  *.microsoft.com , it has to be the exact URL or IP )      So I am looking for informaiton on what other URLs  the installer will need. 

[bobo256]

Hi, 

Did you manage to solve this issue ? I'm in the same situation trying to set up the gateway but need to know what ips and domains to whitelist and allow..