Excel Power Query Cache Folder

Hi darentengmfs ,

These caches are for the data preview in Power Query. Removing these will have no effect on your query refresh speeds, as refreshes are performed Wipe > Reload > Transform, no cache read.

If you delete these caches, it will make the PQ preview window load slower until new cache files for frequently-viewed queries are created again.

If you want to control the size of these cache files on your machine, then you can adjust the size-on-disk setting here:

If you hover over the info (i) icon I've circled, there's an explanation available.

As you can see, I'm happy to allocate ~20GB for these caches as I have plenty of HDD space, and I like my frequently-used query previews to load fast.

Pete

Hi darentengmfs 

Do you need those old cache files? Since you are refreshing these queries every day, if you don't need the cache data in previous days, i think it is ok to remove those old cache files. Every time when it refreshes the queries, it will connect to the data sources to query data and load them into files instead of querying data from the cache. 

Best Regards,
Community Support Team _ Jing
If this post helps, please Accept it as Solution to help other members find it.