Hi @rhashhab
The error you’re encountering — “ODBC: ERROR [HY000] HTTP status code: 403 … Authentication failed” — indicates that Power BI is unable to authenticate successfully with your ClickHouse database, even though your credentials appear correct. Since your colleague can connect using the same username and password, the issue is likely related to your local environment or connection path, not the database itself. Because you’re connecting through port forwarding in Visual Studio, it’s possible that your forwarded port session has expired, isn’t properly mapped, or is pointing to a different endpoint than your colleague’s. Another common cause is that your ODBC DSN or connection string stores cached credentials or references an older authentication method that ClickHouse rejects. To fix this, first verify that your port forwarding session is active and that the local port matches the one your colleague uses. Then, delete and recreate your ODBC DSN or Power BI connection to ensure it’s not using cached credentials. If the issue persists, try connecting via ClickHouse client or DBeaver using the same credentials — if that works, the problem lies specifically in your Power BI or ODBC configuration.
Did I answer your question? Mark my post as a solution, this will help others!
If my response(s) assisted you in any way, don't forget to drop me a "Kudos"
Kind Regards,
Poojara - Proud to be a Super User
Data Analyst | MSBI Developer | Power BI Consultant
Consider Subscribing my YouTube for Beginners/Advance Concepts: https://youtube.com/@biconcepts?si=04iw9SYI2HN80HKS
