Power BI Desktop fails to connect to Azure Data bricks

[Anonymous]

Hey, has anyone encountered and resolved the following error when trying to connect to Azure Databricks from PowerBI Desktop?

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

I've tried different approaches:

1) With and without corporate VPN enabled on my laptop

2) Authentication using both personal access token and Azure sign-in

3) Sources: Azure Databricks and Spark

And get the same error message.

PowerBI Desktop version is 2.100.1182.0 64-bit (December, 2021)

[v-jingzhang]

Hi @Anonymous 

Have you referred to this document (https://docs.microsoft.com/azure/databricks/integrations/bi/power-bi) when you connected to Azure Databricks? You were using Import or DirectQuery to connect to Azure Databricks? Did you have this issue for the same data source before?

Best Regards,
Community Support Team _ Jing