MetricSign
EN|NLRequest Access
Critical severitydbt

Power BI Refresh Error:
Connection Error

What does this error mean?

Dbt could not establish a connection to the target warehouse. The run was aborted before any models executed because the warehouse endpoint was unreachable, credentials were invalid, or the network path was blocked.

Common causes

  • 1Warehouse credentials in the dbt Cloud environment profile are expired or incorrect (rotated service account key or password change)
  • 2The warehouse endpoint URL or account identifier changed (common after Snowflake account migrations)
  • 3Network security rules (IP allowlist, VPC, firewall) block the dbt Cloud IP ranges from reaching the warehouse
  • 4The target warehouse or database does not exist or was renamed
  • 5Warehouse is paused, suspended, or in maintenance mode

How to fix it

  1. 1In dbt Cloud, go to Account Settings → Credentials and test the connection — this validates credentials without running a full job.
  2. 2Verify the warehouse account identifier, host, port, and database name in the dbt Cloud environment settings.
  3. 3Check whether the warehouse has an IP allowlist and add the dbt Cloud IP addresses (published in dbt Cloud documentation).
  4. 4If using Snowflake, verify the virtual warehouse (compute cluster) is not suspended — auto-suspend can cause connection timeouts.
  5. 5Check the warehouse's audit logs for failed authentication attempts to confirm whether the issue is credentials or network.

Frequently asked questions

How do I test the dbt Cloud connection without running a full job?

In dbt Cloud, go to Account Settings → Connections, select your connection, and click 'Test Connection' to validate credentials and network path in seconds.

My connection worked yesterday but fails today — what likely changed?

Most commonly a credentials rotation (password change, key rotation, OAuth expiry) or a new IP allowlist rule. Check the warehouse audit log and your secrets management system.

Does a dbt Cloud connection error mean my warehouse is down?

Not necessarily — the warehouse can be operational while dbt fails due to expired credentials, a changed endpoint, or dbt Cloud IPs not on the allowlist. Run the connection test in dbt Cloud settings to isolate.

Official documentation: https://docs.getdbt.com/guides/debug-errors

Other dbt errors