On-premises Data Gateway is Creating Junk Folders in the Root of the C-Drive

[vitoriamariabr]

Hello!
I'm having a recurring problem with On-premises Data Gateway. Every day a cache folder is created in the root of the C-drive and it consumes a lot of my computer's memory, I have to restart it every morning. 

I have installed the latest version of On-premises Data Gateway but the problem continues.
I've seen similar posts but the only one that seems to have worked was to change the path of this cache folder to another place.

Does anyone know how to solve this problem?

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

[v-kongfanf-msft · Accepted solution]

Hi @vitoriamariabr ,

As you say, changing the path to the cache folder to another location with more free space can alleviate this problem.

Another option could require you to know a little bit about powershell programming. Scheduled tasks can be created to monitor the size of the cache folder and automatically purge old files based on your organization's data retention policies.

You need to install related package.

Install-Module -Name DataGateway

For more details, you can refer to below document:

PowerShell Cmdlets for On-premises data gateway management | Microsoft Learn

Best Regards,
Adamk Kong

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

[vitoriamariabr]

Thanks! I'll try these solutions!