metricsign
Start free
Low severityconfigurationSnowflake

Power BI Refresh Error:
251006

What does this error mean?

The Python connector is using password-based authentication but no password was provided. This error occurs when the password parameter is omitted or empty for a connection that requires it.

Common causes

  • 1The password parameter was omitted from the connect() call while using default (password) authentication
  • 2Environment variable supplying the password is not set or empty
  • 3The password was accidentally set to None in the application configuration
  • 4Secrets manager or vault returning an empty value for the password key
  • 5Using password auth instead of the intended key-pair auth — missing both authenticator and private_key

How to fix it

  1. 1Add password='<password>' to the connect() call, or source it from a secure env var.
  2. 2Verify the env var: printenv SNOWFLAKE_PASSWORD (use a secure method — avoid echoing passwords in logs).
  3. 3If the intent is to use key-pair auth, add authenticator='snowflake_jwt' and private_key instead of password.
  4. 4Rotate secrets in the vault and ensure the pipeline re-reads the updated value.
  5. 5For local development, use a .env file with python-dotenv and confirm it is loaded before connect().

Frequently asked questions

Should I hardcode passwords in Python scripts?

Never — use environment variables, a secrets manager (AWS Secrets Manager, HashiCorp Vault, Azure Key Vault), or Snowflake's connections.toml with OS-level permissions.

Is there a better auth method for service accounts than passwords?

Yes — key-pair authentication (JWT) is recommended for automated pipelines. It avoids password rotation headaches and supports fine-grained access control.

Official documentation: https://github.com/snowflakedb/snowflake-connector-python/blob/main/src/snowflake/connector/errorcode.py

Other configuration errors