Forum Discussion

garynorcrossmmc's avatar
garynorcrossmmc
Advocate IV
1 year ago
Solved

Databricks Error (SSL Certificate) With Refresh

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-19j...
  • v-csrikanth's avatar
    1 year ago

    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.