Forum Discussion
How to access Azure SQL Database without allowing public network access
Unfortunately no, Data Pipeline doesn't support Data Gateway - this is the reason why I'm raising this question here.
It is clear from here https://learn.microsoft.com/en-us/data-integration/vnet/overview
and I've just tried on a real Fabric instance
Could you suggest how to get that IP range? because maintaining VM is not suitable for us.
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
