Power BI Connection Issue with Simba ODBC Driver and Kyuubi Authentication

Hi ratheeshkumar ,
Based on your error message, it appears that SASL authentication failed and password or username authentication was not passed. The error message returned by the Kyuubi server remains unchanged even if incorrect credentials are entered.
This may be due to the following reasons:
1. SASL Configuration Problems: The SASL protocol between the Simba ODBC Driver and Kyuubi may not be properly negotiated or configured.
2. Driver version compatibility: Compatibility issues between the Simba ODBC Driver version and the Kyuubi version.
3. As you mentioned the Simba ODBC Driver may have changed passwords or performed other incorrect processing during the transfer.
Here are some suggestions for you:
1. You can check the logs of both Simba and Kyuubi: By checking the logs, you can learn more about the root cause of the authentication failure. Typically, Kyuubi will provide more details about the authentication failure, from which you can figure out if it was a password, username, or other authentication configuration problem.
2. If you are using the Simba Spark ODBC driver to connect to Kyuubi, make sure that the Simba version is compatible with the Kyuubi version. Some Kyuubi versions (e.g. 1.5.x) may have compatibility issues with older Simba drivers.
[Bug] Connect from PowerBI · Issue #3032 · apache/kyuubi · GitHub
If the above suggestions do not fully resolve your problem, you should contact Simba Technical Support or Kyuubi Technical Support and provide them with detailed error logs and configuration information so that they can help you diagnose and resolve the problem.

Hope it helps!

Best regards,
Community Support Team_ Tom Shen

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.