Databricks Error (SSL Certificate) With Refresh

[garynorcrossmmc]

Hi all, 

I'm trying to connect to our databricks server using the following code:
Databricks.Query("adb-XXXX51515437742.2.azuredatabricks.net", "sql/protocolv1/o/XXXX051515437742/1210-163745-19j9k0vp", [Catalog="hive_metastore", Database=null, EnableAutomaticProxyDiscovery=null, ConnectionTimeout=180])

And then receiving this error constantly when trying to load the data into Power BI:
ODBC: ERROR [08S01] [Microsoft][Hardy] (115) Connection failed with error: SSL_read: error code: 0

This makes ZERO sense because my account information is correct, I've recently downloaded the certificates and I am connected to my company's VPN correctly to access the server.  When I apply transformations in Power Query, I'm able to see the data, but it will not load into the design view (failing after about a minute).  Why is this happening?

[v-csrikanth · Accepted solution]

Hi @garynorcrossmmc
Thank you for being part of the Microsoft Fabric Community.

Please do check the below points that might resolve your issue. 

• Make sure SSL is enabled in the ODBC driver settings.

• Check that the certificate used by Databricks is from a trusted Certificate Authority (CA).

• If you're using a VPN or proxy, verify it isn’t intercepting or altering SSL traffic.

• Ensure the Databricks cluster you're connecting to is running and reachable.

• Use the latest version of Power BI Desktop—older builds can have SSL compatibility issues.

• In your microsoft.sparkodbc.ini file, enable detailed error logging:
  [Driver]
  AllowDetailedSSLErrorMessages=1
  EnableCurlDebugLogging=1
• Review the latest official guidance here: Power BI with Azure Databricks

If the above information is helpful, please give us Kudos and mark the response as Accepted as solution.
Best Regards,
Community Support Team _ C Srikanth.