Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
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?
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):"
Proud to be a Datanaut!
Private message me for consulting or training needs.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.