How to know IPs related to Powerbi online for Opening Firewall Port

[suusin]

Here is a listing of the fully qualified domain names used by the gateway.

Domain names	Outbound ports	Description
*.download.microsoft.com	80	HTTP used to download the installer.
*.powerbi.com	443	HTTPS
*.analysis.windows.net	443	HTTPS
*.login.windows.net	443	HTTPS
*.servicebus.windows.net	5671-5672	Advanced Message Queuing Protocol (AMQP)
*.servicebus.windows.net	443, 9350-9354	Listeners on Service Bus Relay over TCP (requires 443 for Access Control token acquisition)
*.frontend.clouddatahub.net	443	HTTPS
*.core.windows.net	443	HTTPS
login.microsoftonline.com	443	HTTPS
*.msftncsi.com	443	Used to test internet connectivity if the gateway is unreachable by the Power BI service.
*.microsoftonline-p.com	443	Used for authentication depending on configuration.

Our company has strict policy for firewall management, we need to know IPs for these domain names in order to open related ports of firewall. i know Microsoft Azure Datacenter IP list.  but it is not used because our firewall team need to know the detailed information

for example, 123.123.123.1233   443 for opening

[Anonymous]

For me this thread solved the issue: https://community.powerbi.com/t5/Service/API-requires-Power-Bi-Ip-address-range-to-Whitelist/td-p/25...

There is a link to the list of IP addresses used by Microsoft data center. You can also see in the authorization or refresh error in Power BI Service the IP address that is used by your data center so you can easily pick the full range from the list in the referenced thread.

[Jayesh_IFI]

 Hi @suusin ,

We are facing kinda same issue. Can you please help me with IP lists you might have got ?

It would be very helpful.

Thank You.

[ybd]

Having the same issue. We want to use FQDN on any other way wo allow power bi service to have a remote access to our MYSQL DB hosted in GODADDY.

We have try tu use this:

*.powerbi.com

We dont find any documentaion regarding this issue - we can know what will be the PBI Service ip address when it will access our MySql Database remotlly

[v-qiuyu-msft]

Hi @suusin,

Based on my research, I didn't found this kind of information. Maybe you can create a support ticket to get support from Microsoft engineer. 

Best Regards,
Qiuyun Yu