Power BI Refresh Error:
SYNAPSE_SQL_0005

What does this error mean?

The Synapse dedicated SQL pool has insufficient Data Warehouse Units (DWUs) to execute the query and it has been queued or rejected.

Common causes

• 1Multiple concurrent queries exceeding the pool's concurrency slots for the DWU level
• 2DWU level is too low for the workload (e.g., DW100c for production ETL)
• 3Long-running queries holding concurrency slots and starving other workloads
• 4Resource class of the user is too high, consuming too many concurrency slots per query

How to fix it

1. 1Step 1: Check active queries: `SELECT * FROM sys.dm_pdw_exec_requests WHERE status = 'Running';`
2. 2Step 2: Check concurrency slot usage: `SELECT * FROM sys.dm_pdw_resource_waits;`
3. 3Step 3: Scale up DWUs temporarily: portal > Dedicated SQL pool > Scale.
4. 4Step 4: Lower the resource class of ETL users: `EXEC sp_addrolemember 'smallrc', '<user>';`
5. 5Step 5: Implement workload management groups and classifiers to prioritize critical queries.

Frequently asked questions

Other capacity errors