Forum Discussion
How to link SQL server in private network from pipeline in Fabric?
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
Community ChampionIt'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