Power BI Refresh Error:
SYNAPSE_SQL_0002

What does this error mean?

Authentication failed when connecting to the Synapse dedicated or serverless SQL pool.

Common causes

• 1Wrong username or password in the linked service or connection string
• 2Azure AD user or service principal does not have the db_datareader or required role
• 3Service principal client secret expired
• 4Firewall rule or private endpoint configuration blocking the connection

How to fix it

1. 1Step 1: Verify the username and password or service principal credentials.
2. 2Step 2: In Azure Synapse Studio, check the user's database role: `SELECT IS_MEMBER('db_datareader');`
3. 3Step 3: Grant the required role: `ALTER ROLE db_datareader ADD MEMBER [user@domain.com];`
4. 4Step 4: Check the Synapse workspace firewall and add the client IP if needed.
5. 5Step 5: If using a service principal, verify it is not expired in Azure Entra ID.

Frequently asked questions

Other permissions errors