Low severityquery
Power BI Refresh Error:
DM_GWPipeline_Gateway_QueryCancelledByUser
What does this error mean?
The refresh query was cancelled before it completed. This can be triggered manually or automatically by the system when a timeout or resource limit is reached.
Common causes
- 1A user manually cancelled the refresh from Power BI Service
- 2The refresh exceeded the maximum allowed duration (2 hours for Pro, up to 5 hours for Premium)
- 3The gateway cancelled the query because the connection was lost
- 4A parallel refresh job was cancelled to free resources for a higher-priority task
- 5Power BI Service maintenance caused in-progress refreshes to be cancelled
How to fix it
- 1If manually cancelled: identify why and re-trigger the refresh when appropriate
- 2If the refresh regularly exceeds the time limit, implement incremental refresh to process only new rows
- 3Optimize the slowest Power Query steps — use query folding to push filtering to the database
- 4Consider scheduling large refreshes during off-peak hours when there is less capacity contention
- 5Monitor refresh duration trends with MetricSign to catch when a dataset starts taking progressively longer