cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
maximus8557
Helper II
Helper II

Change Enterprise Gateway Spooler folder location to different drive

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.

2 ACCEPTED SOLUTIONS
v-diye-msft
Community Support
Community Support

Hi @maximus8557 

 

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/

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

View solution in original post

PowerDAX
Resolver III
Resolver III

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>

powerdax.com

View solution in original post

7 REPLIES 7
PowerDAX
Resolver III
Resolver III

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>

powerdax.com

Thanks man. It works and I managed to change the spooler location to my SSD drive.

 

Regards,

Max

Hi, @maximus8557 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 @masari23 ,

 

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,

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?

 

 

v-diye-msft
Community Support
Community Support

Hi @maximus8557 

 

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/

Support Ticket.gif

Community Support Team _ Dina Ye
If this post helps, then please consider Accept it as the solution to help the other members find it more
quickly.

Thanks for the reply.

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.

Thanks again

Helpful resources

Announcements
September Update

Check it Out!

Click here to learn more about the September 2022 updates!

Power BI Show Episode 10 Recap

The Power BI Community Show

Watch the playback when Amit Chandak, a Power BI Super User, demos how to use Field Parameters to make reports more dynamic.

Power BI Dev Camp Session 26

New Date - Check it Out!

Mark your calendars and join us on Thursday, October 6 at 11a PDT for a great session with Ted Pattison!

Health and Life Sciences Power BI User Group

Health and Life Sciences Power BI User Group

Power BI specialists at Microsoft have created a community user group where customers in the provider, payor, pharma, health solutions, and life science industries can collaborate.

Top Solution Authors