Forum Discussion
Marusyk
Advocate II
Advocate IIHow to access Azure SQL Database without allowing public network access
Of course, my production database is accessible only from specified vNets. How can I access it from Data Pipeline in Microsoft Fabric? I found the following options: Managed Private En...
MarusykAdvocate II
Advocate IIUnfortunately 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.
NandanHegde
Super User
Super UserHey,
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