What causes DM_GWPipeline_Gateway_QueryCancelledByUser?

A user manually cancelled the refresh from Power BI Service. The refresh exceeded the maximum allowed duration (2 hours for Pro, up to 5 hours for Premium). The gateway cancelled the query because the connection was lost. A parallel refresh job was cancelled to free resources for a higher-priority task. Power BI Service maintenance caused in-progress refreshes to be cancelled

How do I fix DM_GWPipeline_Gateway_QueryCancelledByUser?

If manually cancelled: identify why and re-trigger the refresh when appropriate.. If the refresh regularly exceeds the time limit, implement incremental refresh to process only new rows.. Optimize the slowest Power Query steps — use query folding to push filtering to the database.. Consider scheduling large refreshes during off-peak hours when there is less capacity contention.. Monitor refresh duration trends with MetricSign to catch when a dataset starts taking progressively longer.

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.

Frequently asked questions

Does this error only affect the dataset or also the report?

The error occurs during the refresh — if the refresh fails, the report shows the last successfully loaded data, not an error. Users won't see a broken report, but the data will be stale.

How do I find which Power Query step is causing the error?

Open Power BI Desktop and attempt a refresh. Power Query highlights the failing step in the Query Editor. The error message typically includes the table name and step name.

Can query errors be caused by data changes in the source?

Yes — if the source returns a data type the query doesn't expect (e.g., a null value in a previously non-nullable column), the query evaluation fails.

Does this error affect all tables in the dataset?

Usually only the table whose query evaluation failed. Other queries in the dataset may succeed unless they depend on the failed query's output.

Source · learn.microsoft.com/en-us/power-bi/connect-data/service-gateway-onprem-tshoot