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

     

     

arvindsingh802's avatar
arvindsingh802
Community Champion
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

 

 

  • idarif2007's avatar
    idarif2007
    New Member
    6 months ago

    hello team,

     

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

    Regards,

    Arif