How to change the cache location for On-Premise Gateway

[Anonymous]

Does anyone know how to change the location of temporary cache files for on-premise gateway?

The C: drive on my gateway server is running out of space and I'd like to move the gateway cache files to a drive with more available space.

The gateway is writing data to C:\Users\PBIEgwService\AppData\Local\Temp\Microsoft\MashupProvider\Cache folder

I found a post that showed how to change spooler cache folder, C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\Spooler, by editing a config file.  Hoping for something similar, but I don't find any references in the other config files.

[wdrain]

Did anyone find out if there is way redirect the Cache directory?

[Anonymous]

Hi  @Anonymous ,

Did you refer to this document:

https://community.powerbi.com/t5/Service/Change-Enterprise-Gateway-Spooler-folder-location-to-different/m-p/806405

You can open the configuration file through the reply in the above link, use Ctrl + F to search for keywords, and then find the following similar format to modify

<setting name="SpoolerDirectory" serializeAs="String">
<value>%LOCALAPPDATA%\Microsoft\On-premises data gateway\Spooler</value>
</setting>

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous]

Thanks Liu.  I had viewed that post and it did move the "spooler" directory.  However, it did not move the location of another cache folder which I cited in my original post, and that other directory.  So it really only solved half the problem.

C:\Users\PBIEgwService\AppData\Local\Temp\Microsoft\MashupProvider\Cache