Need Help to Connect ODBC DataSource through VNET Gateway

[Anonymous]

So there is this SQL Server that I need to connect to - I can't use the inbuilt "SQL Server" Get Data feature as the DB requires me to set EnableServerCertificate and Encrypt to true which I can't do. I found a way to do that through an ODBC connection string and everything worked fine in my Desktop. Now this Server also has public access disabled, so to I had to greate a VNET Gateway and whitelist that Subnet. But now it seems like I can't connect directly to that VNET for ODBC sources. 

Does someone know a way to - 

A - Connect this ODBC source to VNET or

B - Connect to SQL Server with the conditions of Encrypt = 'Yes' and TrustServerCertificate = 'Yes'

 Or am I just too lucky?

[collinq]

Hey @Anonymous ,

I do not personally have experience with this, but this article Use virtual network data gateway and data sources in Power BI | Microsoft Learn

states that ODBC is support when "Sources supported through either public endpoints or secure private endpoint connectivity with Express Route or VPNs (scenarios 2 and 3 from above):"