Forum Discussion

jrmkjrm's avatar
jrmkjrm
Frequent Visitor
5 years ago
Solved

How do I prevent caching data for each filter used in DirectQuery?

Hi, In desktop version and with all tables set as DirectQuery, how do I prevent caching data for each filtering? I've noticed that when doing exact the same filtering many times ("that genererates t...
Need Help
  • lbendlin's avatar
    lbendlin
    5 years ago

    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().

jrmkjrm's avatar
jrmkjrm
Frequent Visitor
5 years ago

better, but...

If i check for new max(OrderNo) each minute, my current page with a sum of all orders updates correct each minute (real nice!!!). But if I then (re-)filter on the customer with the new order, the old (cached) customer sum is shown. Only the "on screen" filtering was updatet after a minut. With the customer with a new order selected no new page refresh is done after an extra minute (cause no new OrderNo) so I must manually "Refresh" data anyway, to see the new customer sum.

  • alano's avatar
    alano
    New Member
    2 years ago

    jrmkjrm did you ever get a solution to this? I am running into this issue now.