Forum Discussion
How to link SQL server in private network from pipeline in Fabric?
Community ChampionDid 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.
Advocate IPlease 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
- frithjof_v
It's annoying if VNET Gateway doesn't work with Data pipeline.
I think an F SKU would be okay, I would be surprised if the F capacity license would be a show stopper for using VNET Gateway. However if VNET Gateway is not supported for Data pipeline then this is a show stopper for Data pipeline in this case.
I'm wondering why this page has a green checkmark for Azure SQL database and On-Prem Data Gateway combination:
https://learn.microsoft.com/en-us/fabric/data-factory/pipeline-support#a
Anyway, I guess maybe Data pipeline is not possible for your case due to this connectivity limitation? Workaround is to use Notebook with Managed Private Endpoint or Dataflow Gen2 with VNET Gateway?
We can vote for this Idea to highlight the need:
Add support for PowerBI VNET Gateway in Fabric Pipelines
https://ideas.fabric.microsoft.com/ideas/idea/?ideaid=7e487fec-172a-ef11-8ee8-6045bd7f12d7