Gateway

DM_GWPipeline_Gateway_SpooledOperationMissing

Power BI dataset refresh error: what it means and how to fix it.

What this means

The gateway lost the in-progress operation state (the gateway service restarted mid-refresh, or the host VM was cloned after the gateway was installed).

How to fix it

  1. Check the gateway logs for service restarts.
  2. Do not clone gateway host machines; install the gateway fresh on each host.
  3. Apply host patches outside refresh windows, then retry the refresh.
View on Microsoft Learn

Frequently asked questions

What does the "DM_GWPipeline_Gateway_SpooledOperationMissing" error mean?
The gateway lost the in-progress operation state (the gateway service restarted mid-refresh, or the host VM was cloned after the gateway was installed).
How do I fix it?
Check the gateway logs for service restarts. Do not clone gateway host machines; install the gateway fresh on each host. Apply host patches outside refresh windows, then retry the refresh.
Where does this Power BI refresh error appear?
It appears in a Power BI semantic model's refresh history when a scheduled or on-demand refresh fails.

Related gateway errors

Catch this automatically

RefreshRadar monitors every Power BI dataset refresh and emails you when one fails, with the likely cause and the fix, so you are not hearing about a broken refresh from your stakeholders first.