High severityexecution
Power BI Refresh Error:
100132
What does this error mean?
A Snowflake Task failed during scheduled or manual execution. Error 100132 is a task-level wrapper — the root cause is in the task's SQL body or stored procedure and appears in the task run history.
Common causes
- 1The SQL or stored procedure called by the task contains a runtime error (permission denial, object not found, syntax error)
- 2A predecessor task in the DAG failed, causing dependent tasks to be skipped or fail
- 3The task's WAREHOUSE is suspended and auto-resume is disabled
- 4The task owner role no longer has the required privileges on objects referenced in the task body
- 5The task ran longer than its scheduled interval, causing an overlap conflict
How to fix it
- 1Check task run history: SELECT * FROM TABLE(INFORMATION_SCHEMA.TASK_HISTORY(TASK_NAME => 'my_task')) ORDER BY SCHEDULED_TIME DESC
- 2Inspect the ERROR_MESSAGE column in TASK_HISTORY for the underlying SQL error
- 3Resume the task if it is suspended: ALTER TASK mydb.myschema.my_task RESUME
- 4Verify the task owner role's privileges: SHOW GRANTS TO ROLE task_owner_role
- 5If a predecessor task failed, address that failure first — dependent tasks will not run until the DAG root succeeds
- 6Increase the task schedule interval or optimize the task SQL to prevent overlap