Forum Discussion
Require IP range for whitelisting to access the Azure SQL server database from Power BI service
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
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:
Thankyou selimovd for a quick response.
I'll ask my Azure Team to check that. One question, does it pose any security risk?
Hey PC2790 ,
yes, that setting is right.
The safest approach is to have a computer without internet at all. That would make it hard to steal your data. But it would also limit your possibilities.
Except for that, every access is an additional security risk. Maybe one day there is a bug in the connection between Power BI and Azure SQL, nobody knows that. But as it's used quite a lot and Microsoft is investing a lot to keep Azure safe, I think the risk is acceptable. You always have to decide for yourself.
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/DenSelimovicThis setting doesn't work.
I think that's because I am not using any gateway. I am directly adding credentials in the dataset settings section and directly trying to access the Azure SQL server database.
When I try to refresh the data, it gives e the IP address error and when I add that to the Firewall settings, it works.
The problem is that the IP keeps on changing every now and then and that is why I needed a range of IPs to be whitelisted.
I hope I was able to make you understand my requirement.