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
This 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.
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
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