Forum Discussion
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 do schedule refreshes from the Azure SQL database.
Can anyone please help me out here?
Thanks
Hi PC2790 ,
Would you please try to refer to the similar post:
https://www.dutchdatadude.com/azure-sql-firewall-settings-for-power-bi-refresh/
https://gist.github.com/nyanhp/ee2367de57c40c8d3ed3eb7dab6b1233
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
8 Replies
Hey PC2790 ,
you don't really need that. Just go to your Azure SQL and allow Azure services in the firewall settings:
Like this Power BI Service can connect to your database.
Check the following article how to do that:
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍Best regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovicPC2790 v-deddai1-msft selimovd
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?
