Forum Discussion

Maks_Zarin's avatar
Maks_Zarin
Regular Visitor
9 years ago

Pronlem with Cache

Hello.
I have a problem with displaying data for live connection to analisys analysis services database. When I put a filter by categories, total sum is calculated without it:

I think that the total sum is taken from the cache, which has a bug. The cache-clearing feature in powerBI does not help.

without filter

with filter

Reports

4 Replies

  • v-haibl-msft's avatar
    v-haibl-msft
    Microsoft Employee
    9 years ago

    Maks_Zarin

     

    This should be as designed since Power BI has a client query result cache to reduce the amount of query data request to server. If the query generated by user interaction was cached, then user will see the cached data unless they click the refresh button.

    You can also try to set the maximum cash size to be smaller in Options – Data Load to see if it helps. And There is a related idea here.

     

    Best Regards,

    Herbert

    • Maks_Zarin's avatar
      Maks_Zarin
      Regular Visitor
      9 years ago

      Refresh and decreasing the cache to 0 does not help. 
      Is the problem in something else?

      • v-haibl-msft's avatar
        v-haibl-msft
        Microsoft Employee
        9 years ago

        Maks_Zarin

         

        For the total sum, is it a defined measure? If yes, could you please check the formula of it to see if it ignores the category.

         

        Best Regards,

        Herbert