Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi PBI Community,
I am facing the below error message while connecting to Impala Connector.
Unable to Connect
We encountered an error while trying to connect.
Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect."
Any solution/workaround is appreciated.
Thanks,
Pratap
Solved! Go to Solution.
I worked with Microsoft and found a workaround!
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
my ini file looks like below snapshot and it works:
After you have created the file above in that path, close and restart Power BI Desktop if it was running.
hi, @pwanjerkhede
What version of Power BI Desktop do you use? Please update your Power BI Desktop to latest version(2.73.5586.661 64-bit (September 2019) ).
In addition, do you configure SSL for the Impala server? If so, ensure that the SSL protocol version is lower than TLS 1.2.
and also try refer to this blog:
SSL Security Error with Data Source
Regards,
Lin
@v-lili6-msft Thank you for your inputs.
I am using the latest version: 2.73.5586.561 64-bit (September 2019).
I am not sure about configuring SSL for the Impala server.
I am able to connect to Impala through ODBC connection in Power BI but not through the Power BI built-in Impala connector.
ODBC configuration is successful. But the Built in Impala connector is giving throwing below error:
Details: "ODBC: ERROR [HY000] [Microsoft][DriverSupport] (1100) SSL certificate verification failed because the certificate is missing or incorrect."
Thanks,
Pratap
Here is the error snapshot using impala connector
I worked with Microsoft and found a workaround!
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
my ini file looks like below snapshot and it works:
After you have created the file above in that path, close and restart Power BI Desktop if it was running.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
99 | |
83 | |
70 | |
61 |
User | Count |
---|---|
149 | |
114 | |
107 | |
89 | |
67 |