Forum Discussion
How to access Azure SQL Database without allowing public network access
Hey,
The gateway which I meant was Power BI On premises data gateway and not the VNET Data gateway 🙂
The On Premises data gateway is supported for data pipelines and hence suggested to create a VM within the VNET and set up the gateway.
But if that is not possible, you can whitelist the IP range :
https://learn.microsoft.com/en-us/azure/data-factory/azure-integration-runtime-ip-addresses
Hi Marusyk
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet. In case if you have any resolution please do share that same with the community as it can be helpful to others.
Otherwise, will respond back with the more details and we will try to help.
Thanks.
The question is still open!
The answer from Nandan is definitely doesn't help
Marusyk sorry for the delayed response. Can you please confirm what is that you are expecting other than either of the below 2 methods for network access:
1) whitelist the ip range of the data pipeline region in the firewall
2) set up a power bi gateway on a server hosted within the vnet via which you can access the database
I'm expecting that one of "Managed Private Endpoints or Managed virtual networks" or "vNet Data gateway" should work for Data Pipelines - because they are easiest way to securely access the data
