Forum Discussion
How 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...
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