Medium severityconfiguration
Power BI Refresh Error:
002003
What does this error mean?
A Snowflake data share could not be granted to a consumer because the consumer account identifier does not match any known Snowflake account.
Common causes
- 1The consumer account locator or account identifier was entered incorrectly (typo or wrong region suffix)
- 2The consumer account is in a different Snowflake region or cloud provider that does not support cross-region sharing without replication
- 3The consumer account has been suspended or deleted
- 4The consumer is using an account name instead of the account locator
How to fix it
- 1Step 1: Ask the consumer to run SELECT CURRENT_ACCOUNT() in their Snowflake account to get the exact account locator.
- 2Step 2: Verify the region of both provider and consumer accounts — cross-region sharing requires Snowflake data replication.
- 3Step 3: Use SHOW SHARES to confirm the share exists, then GRANT USAGE ON SHARE to the correct consumer account.
- 4Step 4: If cross-region sharing is needed, set up a secondary database using CREATE DATABASE ... AS REPLICA OF.
- 5Step 5: Contact Snowflake support if the consumer account appears valid but cannot be found.