Change Enterprise Gateway Spooler folder location to different drive
Is there any ways that I could change the default Spooler location for Enterprise Gateway? The default location after installation is at C:\Users\PBIEgwService\AppData\Local\Microsoft\On-premises data gateway\Spooler
I wish to change this location path to another SSD drive to speed up the Enterprise Gateway data refresh but could not find where. I tried to reinstall the Gateway to the SSD drive but the spooler location does not change.
But seriously, the spooler location should have been made configurable. Imagine this, most old setup would have their storage in HDD, but when SSD starts to get affordable or the data starts to grow larger, the spooler operation has to run in SSD to maximize its load potential.
Will raise this to support team and hope they would consider this as important in their near future release.
Go to the installation folder of the On-premise Data Gateway. Look for the file Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config. Make a backup first, just in case.
Edit this file in Notepad, look for this part: <setting name="SpoolerDirectory" serializeAs="String"> <value>%LOCALAPPDATA%\Microsoft\On-premises data gateway\Spooler</value> </setting>
Change the value to your preferred folder location. For example: <setting name="SpoolerDirectory" serializeAs="String"> <value>G:\Program Files\On-premises data gateway\Spooler</value> </setting>
Open the On-premise Gateway app, then restart the service for this change to take effect.
I made this change as I want the spooler process to be on a SSD drive. But this can also helps if you are running low on disk space in your current spooler drive. You may switch the spooler folder to a bigger disk drive.