Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
darentengmfs
Post Prodigy
Post Prodigy

Excel Power Query Cache Folder

Hello

 

I have a few Task Scheduler tasks that opens up some excel files and refreshing their queries every few hours every day. There is a folder in the machine that stores these cache files, path below

 

C:\Users\User\AppData\Local\Microsoft\Office\16.0\PowerQuery

 

Some of these caches go back several months. The questions I have are:

  1. What is the impact of my deleting these cache files periodically?
  2. Will it increase the time for my query to refresh if I delete them? 
  3. If it will increase the refresh time, how far back should I keep the cache files? e.g. Cache files from 10 days should be ok to delete

Thanks!

Daren

2 ACCEPTED SOLUTIONS
BA_Pete
Super User
Super User

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:

BA_Pete_1-1657796384512.png

 

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




View solution in original post

v-jingzhang
Community Support
Community Support

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.

View solution in original post

2 REPLIES 2
v-jingzhang
Community Support
Community Support

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.

BA_Pete
Super User
Super User

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:

BA_Pete_1-1657796384512.png

 

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



Now accepting Kudos! If my post helped you, why not give it a thumbs-up?

Proud to be a Datanaut!




Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

Top Solution Authors
Top Kudoed Authors