Skip to main content
    • Knowledge Base/
    ODBC Authentication Failed Error Using Powerbi CH Connector

    ODBC authentication failed error when using the Power BI ClickHouse connector

    ODBC authentication failed error when using the Power BI ClickHouse connector

    Question​

    When trying to connect from PowerBI to ClickHouse using the connector, you receive a authentication error.

    This error usually looks like the following:

    Power BI Error

    Answer​

    Check the password being used to see if the password contains a tilde ~.

    The recommendation is to use a dedicated user for the connection and set the password manually. If using ClickHouse Cloud and the admin level of permissions with the default user is needed, then create a new user and and assign the default_role.

    For more information:
    https://clickhouse.com/docs/en/operations/access-rights#user-account-management
    https://clickhouse.com/docs/en/cloud/security/cloud-access-management#database-roles

    · One min read