Forum Discussion
How do I prevent caching data for each filter used in DirectQuery?
If you need 100% fresh data then you should modify your query by adding a random, meaningless filter.
Let's say you know value A is never more than 50. Add a filter for A<100+RAND().
Super UserYou can disable query caching in the dataset settings on the service.
Thank's but need more help:
I use only the desktop version. I can't find the setting you show me. I find in PowerQuery only the two table properties Activate import and Include in report refresh.
/J
- lbendlin
On the desktop you can manually clear both caches and can restrict the permitted size. File...Options and Settings... Options.
Hi!
Found it, and I tried to set cache size to 0 (despite the warning in the system) to force system to make a new DirectQuery select each time, but it it became impossible to Refresh any data "maximum cahce size exceeded".
I did not found a feature for "clear cache older than x seconds" (for me 0 seconds :)), is there?
Maybe we must live with this: If one need 100% fresh data, one must use Refresh button? A user can of course not remember if a certain filter has been used (on now cached) since opened the report.
- lbendlin
If you need 100% fresh data then you should modify your query by adding a random, meaningless filter.
Let's say you know value A is never more than 50. Add a filter for A<100+RAND().