Hello,I’m facing an issue in Power BI when trying to access data through my gateway. I receive the following error message:Error Message:DM_GWPipeline_Gateway_SpooledOperationMissingDetails:Cluster URI: WABI-BRAZIL-SOUTH-B-PRIMARY-redirect.analysis.windows.netActivity ID: e73a25f6-8117-479e-ab73-20295978c63eRequest ID: ece5a590-f664-6b2c-570d-2e1c52cc4ab7Time: 2025-12-29 11:27:18ZContext:Power BI Gateway version: [Add your gateway version if known]Data Source: [Describe the source, e.g., SQL Server, Excel, etc.]Data refresh operation: [Manual or scheduled refresh?]Any recent changes made in the setup: [If relevant]Could someone guide me on how to resolve this error or any troubleshooting steps to follow?Thank you in advance for your help!

Hi lariane ,Welcome to the Power BI Community.This is a somewhat rare but specific error. The DM_GWPipeline_Gateway_SpooledOperationMissing error essentially means that the Power BI Service tried to retrieve a result set that the Gateway had supposedly prepared (spooled), but the Gateway could not find it.This usually happens for one of three reasons:The Gateway Service Restarted: If the On-Premises Data Gateway service crashed or restarted during the query execution, the temporary "spool" files are lost.Disk Space Issue: The Gateway machine ran out of disk space while trying to buffer (spool) a large dataset.Aggressive Cleanup: An antivirus or system process deleted the temporary files in the Gateway's spool directory.Here are the troubleshooting steps to resolve this:1. Restart the Gateway Service This is the most effective immediate fix.Log in to the machine running the Gateway.Open the On-premises data gateway app.Go to Service Settings and click Restart now.Alternatively: Open Windows Services (services.msc), find "On-premises data gateway service," and restart it.2. Check Disk Space If you are pulling a large amount of data, the Gateway needs significant space to "spool" that data before sending it to the cloud.Check the drive where the Gateway is installed (usually C:\).Ensure there is ample free space (at least 2-3 times the size of the dataset you are refreshing).3. Update the Gateway Since today is December 29, 2025, ensure you are running the latest version (likely the December 2025 or November 2025 release). Older versions may have memory management bugs that cause the service to crash and lose the spooled operation.4. Check for "Double Hop" or Network Latency If this error persists, it might be due to a network timeout between the Gateway and the Data Source, causing the spooling session to expire.Try reducing the amount of data (filter by date) to see if a smaller dataset succeeds.Start with a simple service restart; that solves this issue 90% of the time.If my response resolved your query, kindly mark it as the Accepted Solution to assist others. Additionally, I would be grateful for a 'Kudos' if you found my response helpful.This response was assisted by AI for translation and formatting purposes.

Power BI Error: DM_GWPipeline_Gateway_SpooledOperationMissing – Gateway Data Operation Issue

Forum Discussion

Related content

Scheduler Failed Running: DM_GWPipeline_Gateway_SpooledOperationMissing

DM_GWPipeline_Gateway_SpooledOperationMissing and DM_GWPipeline_Gateway_DataSourceAccessError error.

English translation of this error: DM_GWPipeline_Gateway_SpooledOperationMissing

SQL Operator with multiple destinations

Use Wildcard Operator