What causes 003001 (42501)?

The role lacks the required privilege for DDL operations (CREATE, DROP, ALTER). USAGE is missing on the warehouse, preventing the role from using compute. The role lacks OPERATE privilege on the warehouse to start/suspend it. Trying to access a Snowflake share without the required IMPORTED PRIVILEGES grant. A secondary role is not active and the required privilege is only on that role

How do I fix 003001 (42501)?

Identify the required privilege from the error message. Grant the required privilege to the role: GRANT ON TO ROLE . For warehouse access: GRANT USAGE ON WAREHOUSE TO ROLE . Use SHOW GRANTS TO ROLE to audit current privileges. If using secondary roles, activate them with USE SECONDARY ROLES ALL

High severityaccess control

Power BI Refresh Error:
003001 (42501)

What does this error mean?

The current role does not have sufficient privileges to perform the requested operation on the Snowflake object. This runtime privilege error occurs when the operation is attempted (as opposed to 001044, which is caught at compilation).

Common causes

1The role lacks the required privilege for DDL operations (CREATE, DROP, ALTER)
2USAGE is missing on the warehouse, preventing the role from using compute
3The role lacks OPERATE privilege on the warehouse to start/suspend it
4Trying to access a Snowflake share without the required IMPORTED PRIVILEGES grant
5A secondary role is not active and the required privilege is only on that role

How to fix it

1Identify the required privilege from the error message
2Grant the required privilege to the role: GRANT <privilege> ON <object_type> <name> TO ROLE <role>
3For warehouse access: GRANT USAGE ON WAREHOUSE <wh> TO ROLE <role>
4Use SHOW GRANTS TO ROLE <role> to audit current privileges
5If using secondary roles, activate them with USE SECONDARY ROLES ALL

Frequently asked questions

How is 003001 different from 001044?

001044 is caught at SQL compilation (before execution). 003001 occurs at runtime when the privilege is checked during the actual operation.

What privileges are needed to create a table?

CREATE TABLE on the schema (or higher), plus USAGE on the database and schema.