topic Re: SSL_connect: certificate verify failed with Power BI in Data Engineering

SSL_connect: certificate verify failed with Power BI

andr3s — Fri, 19 May 2023 15:14:07 GMT

Hi,

I'm getting this error with Power BI:

Any ideas?

Thanks in advance,

Andres

Re: SSL_connect: certificate verify failed with Power BI

Harrison_S — Fri, 09 Jun 2023 17:35:50 GMT

Hi Andres,

It looks like it is failing on the SSL Certificate. Can you confirm you setup SSL correctly?

https://kb.databricks.com/bi/powerbi-proxy-ssl-configuration

Re: SSL_connect: certificate verify failed with Power BI

andr3s — Mon, 19 Jun 2023 10:12:49 GMT

Hi Harrison, thanks for the reply. We have sorted the issue a few days later but forgot to reply to your answer. There had been some changes on the security set-up that affected our connectivity to Databricks from all clients.

Re: SSL_connect: certificate verify failed with Power BI

TimAtGSB — Wed, 18 Oct 2023 04:20:59 GMT

@andr3s I am having same issues, would you mind hinting at what the solution was please?

Re: SSL_connect: certificate verify failed with Power BI

sravan4049 — Tue, 20 May 2025 20:28:20 GMT

Could you ming sharing the security configuration changes applied at your end to fix the issue. I am seeing the same problem at my end and could not figure out the root cause

Re: SSL_connect: certificate verify failed with Power BI

benjaminpieplow — Fri, 20 Jun 2025 06:21:02 GMT

We had a very similar issue. The full (redacted) error from Power BI:

```

Unable to update connection credentials. Unable to connect to the data source. Either the data source is inaccessible, a connection timeout occurred, or the data source credentials are invalid. Please verify the data source configuration and contact a data source administrator to troubleshoot this issue.


Details: AZURE_VNET_NAME: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (14) Unexpected response from server during a HTTP connection: SSL_connect: certificate verify failed. Please have this information handy if you choose to create a support ticket. Session Id: SESSION_ID_GUID RequestId: REQUEST_ID_GUID Cluster URI: https://api.powerbi.com Status code: 400 Time: TIMESTAMP

```

The solution was to allow the digicert CRLs through the firewall. These can be found here https://knowledge.digicert.com/alerts/digicert-certificate-status-ip-address

If this does not help, it might be worth checking your firewall for other :80 connection attempts.

Re: SSL_connect: certificate verify failed with Power BI

Isi — Sat, 21 Jun 2025 14:46:34 GMT

Hey @andr3s @benjaminpieplow @sravan4049 @TimAtGSB !

This has happened to me in corporate environments where the company provided me with the platformed computer for their network controls, etc. In my case, we had to disable the Netskope Client (a lightweight application that secures user traffic) because it was causing connectivity issues. If you're working in a similar environment, I recommend checking with your IT service.

Hope this helps, 🙂

Isi

Re: SSL_connect: certificate verify failed with Power BI

nvashisth — Wed, 30 Jul 2025 14:33:08 GMT

Hi @andr3s , @benjaminpieplow , @sravan4049 , @TimAtGSB , @Isi Yes in my case also it was Netskope which was prohibiting the connection from Power BI desktop to Databricks.

As a remedy, I discussed with security team to add *.azuredatabricks.net to security rules which allowed direct connection to databricks which avoided encryption/decryption done by Netskope and hence resolved the issue.

Thanks!

Nitin

Re: SSL_connect: certificate verify failed with Power BI

GaneshKrishnan — Mon, 15 Sep 2025 06:30:17 GMT

In the proxy setup, PowerBI is not aware of process to fetch intermediate certificate like a browser. hence it fails. Recent PowerBI comes with additional option such as
"Automatic Proxy Discovery (Optional): Enabled
"Implementation (optional) : 2.0(beta)

By enabling this option, PowerBI is capable of detecting intermediate certificate and connects without SSL error