Forum Discussion
Impala - Failed to update data source credentials
This is the error I got trying to refresh data from Impala. Failed to update data source credentials: ODBC: ERROR [HY000] [Microsoft][ThriftExtension] (0) Failed to initialize SASL client library...
bump same issue here
I worked with Microsoft and found a workaround!
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\ODBC Drivers\<Simba Driver Name>
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.
pwanjerkhede thank you so much for helping with solution, it worked
An update to the path for Gateway- For On-premise data gateway: C:\Program Files\On-premises data gateway\m\ODBC Drivers\<Simba Driver Name>
