Connect to Azure SQL Server in Service (Azure Firewall and IP Addresses)

[DebbieE]

When you connect to an Azure SQL database in desktop you need to provide your IP Address to the Azure Server Firewall or else you cant connect

If you create your data in a dataflow do you need to provide the IP address of the Data center to the Azure Firewall or is this not required

I think when you get across to power BI Service this isnt required

[V-lianl-msft]

Hi @DebbieE ,

Hope this can help you:

https://community.powerbi.com/t5/Service/Whitelisting-of-PowerBI-IP-address-range-in-Firewall/m-p/10... 

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

[DebbieE]

Sorry, I am not getting what i need from the whitepaper

All i need to know is If you create your data in a dataflow do you need to provide the IP address of the Data center to the Azure Firewall or is this not required?