Forum Discussion

martin-z's avatar
martin-z
Frequent Visitor
7 years ago
Solved

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 ...
Need Help
Tutorial Requests
  • arvindsingh802's avatar
    arvindsingh802
    4 years ago

    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