March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early bird discount ends December 31.
Register NowBe one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now
Hi,
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.
Any advise?
Thanks.
Solved! Go to Solution.
Hi @Anonymous
Based on my research, it's not able to change the location after installation.
I'd suggest you raising it to support team for further advice:
https://powerbi.microsoft.com/en-us/support/
FYI - if anyone comes across this, in the install director, this file:
Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config
has this setting configuration:
<setting name="SpoolerDirectory" serializeAs="String">
<value>%LOCALAPPDATA%\Microsoft\On-premises data gateway\Spooler</value>
</setting>
FYI - if anyone comes across this, in the install director, this file:
Microsoft.PowerBI.DataMovement.Pipeline.GatewayCore.dll.config
has this setting configuration:
<setting name="SpoolerDirectory" serializeAs="String">
<value>%LOCALAPPDATA%\Microsoft\On-premises data gateway\Spooler</value>
</setting>
Does this require to create new directory manually at new SSD locat
Thanks man. It works and I managed to change the spooler location to my SSD drive.
Regards,
Max
Did you create spooler directory manually at new location?
Hi, @Anonymous I am facing a similar issue as this what changes did you make that helped you out of this disk full error? Thanks a lot.
Hi @Anonymous ,
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.
Hope this helps.
Regards,
Max
Hi Max,
Thanks for the information on the SpoolerDirectory change in the config. So I made the change but don't see any files being generated in the new directory on the E drive, do certain accounts have to have rights to writing files to the drive?
Thanks,
Renu
Hi,
We are having an issue like this, in our case the disk keeps running out of space.
Waht was the impact on your proces when chaning this setting? Also, is there a safe way/ automatic way to clean-up this folder?
Hi @Anonymous
Based on my research, it's not able to change the location after installation.
I'd suggest you raising it to support team for further advice:
https://powerbi.microsoft.com/en-us/support/
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
User | Count |
---|---|
36 | |
31 | |
20 | |
11 | |
8 |
User | Count |
---|---|
53 | |
42 | |
28 | |
11 | |
11 |