SSL_connect: certificate verify failed with Power BI

[andr3s]

Hi,

I'm getting this error with Power BI:

Any ideas?

Thanks in advance,

Andres

[Harrison_S]

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

[andr3s]

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.

[TimAtGSB]

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

[sravan4049]

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

[benjaminpieplow]

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.

[Isi]

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

[nvashisth]

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