IBM Support

How reduce OnPremises Data Gateway cache space

How To


Summary

To avoid "out of disk space" errors on windows systems with OnPremises Gateway sevices it is possible to reduce spooler and persistant cache.

Objective

How to reduce used cache of PBI OnPremises Gateway

Environment

Windows Server with PBI OnPremises Data Gateway

Steps

Power BI and the on-premises data gateway create temporary cache files when communicating between the on-premises environment and the cloud in a process called spooling.

Mashup engine uses Persistant cache for query transformations

In case log shows disk space related errors or it is required to free up disk space it is possible to relocate  both caches.

Additional Information

Move Spooler cache:

1.1 Backup and edit   

Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config configuration file in

C:\Program Files\On-premises data gateway directory.

Current Spooler directory location is in <value> tag:

<setting name="SpoolerDirectory" serializeAs="String">

    <value>%LOCALAPPDATA%\Microsoft\On-premises data gateway\Spooler</value>

</setting>

1.2 Replace current location with one which contains enough free space in <value>

1.3 Restart  gateway service.

2. Move Persistent Cache

Change the Windows environment variables for the gateway service account to a location with more space

2.1. Go to System Properties > Environment Variables
2.2. Set TMP and TEMP to a new path (e.g., D:\PowerBIGateway\Temp)
2.3. Restart the gateway service

This change redirects the Mashup engine’s cache to a larger disk.

Document Location

Worldwide

[{"Type":"MASTER","Line of Business":{"code":"LOB66","label":"Technology Lifecycle Services"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SSTIPK","label":"Microsoft Windows"},"ARM Category":[{"code":"a8mKe000000004FIAQ","label":"Power Platform Family"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""},{"Type":"MASTER","Line of Business":{"code":"LOB66","label":"Technology Lifecycle Services"},"Business Unit":{"code":"BU070","label":"IBM Infrastructure"},"Product":{"code":"SSWBPX","label":"Microsoft M365 Platform"},"ARM Category":[{"code":"a8mKe000000004FIAQ","label":"Power Platform Family"}],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":""}]

Document Information

Modified date:
19 August 2025

UID

ibm17242532

Page Feedback