Forum Discussion
How to link SQL server in private network from pipeline in Fabric?
Community ChampionPer my understanding, managed private endpoint is for Spark (Fabric notebook) and Data Gateway is for fabric data factory.
Have you considered the Data Gateway option?
https://learn.microsoft.com/en-us/fabric/security/white-paper-landing-page
I don't have experience with it myself.
Houston-hoAdvocate I
They are 2 different features.
Data gateway is for on-premises data source. Example if you have a virtual machine on Azure, and you have SQL server inside, then you need date gateway to connect to that machine and that SQL database, same as Power BI, Data Factory linked service and Fabric.
For the current case, Azure SQL, probably not Data Gateway.
- frithjof_v
Did you check out the VNET Gateway?
https://learn.microsoft.com/en-us/data-integration/vnet/overview
https://learn.microsoft.com/en-us/data-integration/vnet/use-data-gateways-sources-power-bi
It mentions Azure SQL. However I read someone mention that Data pipeline cannot use VNET Gateway, only On Prem Gateway.
I think the managed private endpoint is only for Spark so I don't think it will work with Data pipeline.
https://learn.microsoft.com/en-us/fabric/security/security-managed-private-endpoints-overview
It's my brief impression.
Edit:
Azure SQL database has a green checkmark for on-premises data gateway on this page: https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-support#a
I'm curious to hear if you find a solution to your case, or if this is not possible to solve with fabric data pipeline.
- Houston-ho
Please note Virtual network data gateway is not the same as data gateway.
VNET data gateways require a Power BI Premium capacity license (A4 SKU or higher or any P SKU). In addition, this feature is available only for Fabric Dataflow Gen2, Power BI semantic models, Power Platform dataflows, and Power BI paginated reports. Power BI dataflows and datamarts are not supported.
What is a virtual network (VNet) data gateway | Microsoft Learn
Meanwhile, On-premise Data Gateway, is FREE to download at below but i don't think that is needed to use it for Azure SQL, indeed you have no place to install it.
Download On-premises data gateway from Official Microsoft Download Center