Power BI Impala connector - SSL certificate error

[martin-z]

Hi, I'm trying to connect to the Impala via Power BI Desktop Impala connector. I'm getting an error: "ODBC: ERROR [HY000] [Micosoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect." I'm getting the same error from the gateway. I don't know where to install the certificate or where to specify path to the certificate. Please help.

[arvindsingh802 · Accepted solution]

As a workaround refer below

You would need to create the microsoft.impalaodbc.ini file inside the path as shown below

• for PowerBI Desktop: C:\Program Files\Microsoft Power BI Desktop\bin\ODBC Drivers\<Simba Driver Name>
• For On-premise data gateway: C:\Program Files\On-premises data gateway\m\ODBC Drivers\<Simba Driver Name>

You will need to put the following 3 lines in the file:

[Driver]

AllowHostNameCNMismatch = 0
CheckCertRevocation = 0

After you have created the file above in that path, you need to restart Power BI Desktop /Gateway service

[idarif2007]

hello team,

it worked for desktop but for gateway it is still breaking.

Regards,

Arif

[v-chuncz-msft]

@martin-z ,

You may try Configuring TLS/SSL for Impala and check if this post helps.