Forum Discussion
Need Help to Connect ODBC DataSource through VNET Gateway
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?
1 Reply
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):"
