Azure Databricks Connector Error: "Certificate chain is not complete"

[Astargle95]

Hello,

   I am trying to connect my Power BI desktop to Azure Databricks through the Azure Databricks connector. I am able to successfully connect through the Spark connector but if I do that, I am not seeing a way to input a SQL query to only import the data I need out of databricks and I cannot import a whole database out of databricks into Power BI. When connecting through the Azure databricks connector, I keep receiving the following error (Image below). At first I had 3 errors, but then I installed the simba ODBC connector and setup the microsoft.sparkodbc.ini file and added the following configuration within the ini file: [Driver] CheckCertRevocation=0. This removed two of the errors.
Now I am left with this. I do not know what I need to do to "complete the certificate chain". I have also established a connection within my ODBC data sources. Any help is appreciated. Thanks!

[Anonymous]

Hi @Astargle95 ,

It seems that there is still problem about the certificate. Maybe you can also try to trust the CA cert on both machines. If issue still persists, I think you can look for help in PostgreSQL community, to find that what certificates need to be installed/trusted on client machine (Power BI Desktop).

Best Regards

Community Support Team _ Polly

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.