Forum Discussion
How to access Azure SQL Database without allowing public network access
Hey Marusyk ,
Based on my understanding Data gateways are now supported for data pipelines as well.
Also, you can set up a VM with small cost within the VNET and install the Power BI gateay in it which you can leverge for your connection ( with more security, there is bound to be some additional cost :))
In case if you want to avoid Gateway and additional costs, there would be some additional maintenance activity like updating the firewall on a yearly basis with IP changes.
Note : You need not whitelist all the fabric IP but only the IP range of the data pipeline in which your fabric capacity is hosted .
The IP range for fabric data pipeline is similar to the IP range of Azure Data Factory as they leverge the same engine/framework
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.
