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 tota...
Reports
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

    • Maks_Zarin's avatar
      Maks_Zarin
      Regular Visitor
      9 years ago

      Hello.
      Total sum is not a defined measure, it is standart feature for visual element 'table'.
      'Выручка' is defined measure in olap-cube, but in excel shows right value.