Forum Discussion

PC2790's avatar
PC2790
Community Champion
5 years ago
Solved

Require IP range for whitelisting to access the Azure SQL server database from Power BI service

Hello,   My Power BI service resides in NORTH EUROPE region and I need the relevant list/range of IPs to be whitelisted in the Firewall settings of Azure in order to enable my report to be able to ...
Need Help
v-deddai1-msft's avatar
v-deddai1-msft
Community Support
5 years ago

Hi PC2790 ,

 

Would you please try to refer to the similar post: 

 

https://community.powerbi.com/t5/Service/Firewall-setup-IP-used-by-Power-BI-Service-during-data-refresh/m-p/135643

 

https://www.dutchdatadude.com/azure-sql-firewall-settings-for-power-bi-refresh/

 

https://gist.github.com/nyanhp/ee2367de57c40c8d3ed3eb7dab6b1233

 

https://medium.com/microsoftazure/how-to-refresh-a-firewall-enabled-azure-data-lake-storage-gen2-data-source-from-power-bi-service-1c5f440cd93b

 

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

 

Best Regards,

Dedmon Dai

PC2790's avatar
PC2790
Community Champion
5 years ago

Thankyou v-deddai1-msft 

It really has some good material to go through.

In the approach where the IPs are getting whitelsited, Is there any way to limit the range for NORTH EUROPE region?

Actually I don't want to go with the gateway approach considering the complexity.

So, want to stil with IP whitelisting thing