Error in connecting with Azure Databricks

[prikha16]

Hi, 

I am trying to connect Power BI desktop to Azure Databricks and I am getting the following error:

Initially it seemed to be a driver issue. I installed the Simba Spark ODBC driver. But after installation, I am still getting the same error. Can anyone please help me with resolution for this one.

Thanks in advance,

DataSource.Error: ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1200)
-The revocation status of the certificate or one of the certificates in the certificate chain is unknown.
-The certificate chain is not complete.
-The revocation status of the certificate or one of the certificates in the certificate chain is either offline or stale.
Details:
DataSourceKind=Databricks
DataSourcePath={"host":"adb-778839714690372.12.azuredatabricks.net","httpPath":"sql\/protocolv1\/o\/778839714690372\/0128-141702-set306"}
OdbcErrors=[Table]

[amitchandak]

@prikha16 , refer this system DSN vs User DSN solution, Couple of topics referring to that

https://community.powerbi.com/t5/Power-Query/Personal-Gateway-X-On-Premises-Gateway/m-p/70945#M5526