Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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:
Thanks!
Daren
Solved! Go to Solution.
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
Proud to be a Datanaut!
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.
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.
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
Proud to be a Datanaut!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
50 | |
19 | |
12 | |
11 |