Forum Discussion
Can Private Azure SQL Server connect to Fabric with cloud connection?
Hi ShairaiAli ,
Thank you for the follow-up.
The Allow this connection to be utilized with either on-premises data gateways or VNet data gateways option is intended for hybrid scenarios where the same connection may need to work in both cloud and gateway-based contexts.
Example use case
You initially configure a Cloud connection from Fabric to an Azure SQL Database that allows public network access. Later, your organization restricts the database to a private endpoint accessible only through a gateway.
By enabling this option, you can reuse the same connection and map it through an on-premises or VNet gateway, instead of creating a new one.In summary, this setting makes the connection eligible for gateway-based evaluations. Dataflows, Semantic Models, Pipelines, etc. but doesn’t change the runtime network path you still need a gateway if the source isn’t publicly accessible.
Thanks,
Akhil.
Hi ShairaiAli ,
It’s been a little while, so I just wanted to check in one last time. Were you able to get chance with the VNet Data Gateway as discussed earlier as suggested?
Since we haven’t heard back, and following the Microsoft Fabric Community Forum guidelines, we’ll go ahead and close this thread for now.
If you're still exploring solutions or need help with anything else in the future, please feel free to create a new post we’re always here to help.
Regards,
Akhil.
Sorry for the delay.
I already tested with on-premises data gateway as well as VNet gateway. Both worked.
If you have tutorial related to that option, kindly send.
