当使用 Power BI ClickHouse 连接器时，ODBC 身份验证失败错误

2024年7月10日 ·一分钟阅读

问题

当尝试使用连接器从 PowerBI 连接到 ClickHouse 时，您收到身份验证错误。

此错误通常如下所示

We encountered an error while trying to connect.
Details: "ODBC: ERROR [HY000] HTTP status code: 403
Received error:
Code: 516. DB::Exception: default: Authentication failed: password is incorrect, or there is no user with such name.
If you have installed ClickHouse and forgot password you can reset it in the configuration file.
The password for default user is typically located at /etc/clickhouse-server/users.d/default-password.xml and deleting this file will reset the password.
See also /etc/clickhouse-server/users.ml on the server where
ClickHouse is installed.

Power BI Error

答案

检查正在使用的密码，看看密码是否包含波浪号 ~。

建议为连接使用专用用户并手动设置密码。如果使用 ClickHouse Cloud 并且需要 `default` 用户的管理员级别权限，则创建一个新用户并分配 `default_role`。

问题​

答案​

问题

答案