Unable to connect Azure Databricks from Power BI (ODBC error)

[hiranyadeka]

Can someone help on my issue:

Error is:

Unable to Connect

Encountered an error while trying to connect:

Details: "ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed."

I am trying to connect from On premise power BI gateway server.

[v-yiruan-msft · Accepted solution]

Hi @hiranyadeka ，

Thanks for reaching out to us with your problem. According to the error message,  it seems that there is a problem with the SSL certificate used in the connection between Power BI and Azure Databricks. In order to make further troubleshooting and give you a suitable solution, could you please check the following info? It would be helpful to find the solution. Thank you.

• Check the Certificate:
  - Ensure that the SSL certificate installed on the Databricks server is valid and has not expired.
  - Verify that the certificate is issued by a trusted Certificate Authority (CA).
• Configure SSL Settings: 
  - In the gateway settings, ensure that the SSL settings are correctly configured to trust the certificate chain.
  - If necessary, you may need to import the CA's root certificate into the gateway's trusted store.

        powerbi - Connectivity issue from Power BI to Azure DataBricks - Stack Overflow

In addition, please review the following links. Hope they can help you.

Connect Power BI to Azure Databricks - Azure Databricks | Microsoft Learn

Solved: Not able to connect to Databricks - ODBC: ERROR [H... - Microsoft Fabric Community

After restarting the computer it worked  =/

---

Best Regards

[hiranyadeka]

Can someone please update or help whats' the way to get powerBI support?