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.