Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
As a workaround refer below
You would need to create the microsoft.impalaodbc.ini file inside the path as shown below
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
You may try Configuring TLS/SSL for Impala and check if this post helps.
User | Count |
---|---|
139 | |
113 | |
103 | |
73 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |