Whitelisting of PowerBI IP address range in Firewall

[Anonymous]

We need to allow only PowerBI service/connectors to access the Azure managed SQL instance. i.e. PowerBI report published in workspace will connect with Azure SQL Managed instance to fetch data. Currently security team has configured firewall which don’t allow any ip address which is not whitelisted. Would you please let us know range of IP address to be whitelisted from PowerBI side so we can make the successful connection to Managed Azure Instance which is behind firewall.

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can download the Microsoft Azure Datacenter IP list, which is updated weekly or configureto allow outbound connections to FQDN's rather than IP's.

You can refer to these thread:https://community.powerbi.com/t5/Service/Mass-IP-Whitelisting-for-Azure-Datacenter/m-p/173665 

https://stackoverflow.com/questions/54456612/how-to-allow-the-azure-data-center-ip-address-dynamically-in-firewall 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[zzeng · Accepted solution]

Update:

the answer in 2020 is deprecating.

Please refer to the latest [Azure IP Ranges and Service Tags – Public Cloud]

https://www.microsoft.com/en-us/download/details.aspx?id=56519

Version:

2024.07.29

Date Published:

7/30/2024

File Name:

ServiceTags_Public_20240729.json

File Size:

3.5 MB

[Marcusfdm1]

do you happen to know which IP address range I should use for Power BI? I noticed "PowerBI" on line 31937, but my Power BI instance is located in West Europe. Should I use the general "PowerBI" range, or one of the more specific options, like:

• "name": "PowerQueryOnline.WestEurope" on line 96272
• "name": "PowerPlatformPlex.WestEurope" on line 94394

I’m a bit unsure which would be best, as I need to whitelist IPs that will reliably allow me to connect to a MySQL database on a Linux server without any issues. Any guidance would be appreciated!

[Marcusfdm1]

@zzeng

do you happen to know which IP address range I should use for Power BI? I noticed "PowerBI" on line 31937, but my Power BI instance is located in West Europe. Should I use the general "PowerBI" range, or one of the more specific options, like:

• "name": "PowerQueryOnline.WestEurope" on line 96272
• "name": "PowerPlatformPlex.WestEurope" on line 94394

I’m a bit unsure which would be best, as I need to whitelist IPs that will reliably allow me to connect to a MySQL database on a Linux server without any issues. Any guidance would be appreciated!

[technolog]

@zzeng thanks for update!😎

[technolog]

@Anonymous @V-lianl-msft 

Please share your experience if possible! How do you have everything set up now? Did everything work stably using ip-whitelist? Have you tried using domains?

[V-lianl-msft · Accepted solution]

Hi @Anonymous ,

You can download the Microsoft Azure Datacenter IP list, which is updated weekly or configureto allow outbound connections to FQDN's rather than IP's.

You can refer to these thread:https://community.powerbi.com/t5/Service/Mass-IP-Whitelisting-for-Azure-Datacenter/m-p/173665 

https://stackoverflow.com/questions/54456612/how-to-allow-the-azure-data-center-ip-address-dynamically-in-firewall 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.