Forum Discussion
Power BI Impala connector - SSL certificate error
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
- 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 = 0After you have created the file above in that path, you need to restart Power BI Desktop /Gateway service
3 Replies
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 = 0After you have created the file above in that path, you need to restart Power BI Desktop /Gateway service
hello team,
it worked for desktop but for gateway it is still breaking.
Regards,
Arif
