Questions about Storage Capability on Automatic Aggregations for DirectQuery

Hi, Charlotte v-zhangti 

Thanks for your answer and I very appreciate for the detailed information you provided.

I still have some confusion about how the auto aggregation works. Would you like to help me to understand more about how the cache will change when I enable auto aggregation?

Question 1:  Where the cache will be stored?

In my understanding, the cache is supposed to store in the workspace storage, which has a limit of 100TB per Premium capacity. Each cache will be created by each dataset, if the auto aggregation enabled.

Question2:  About the query log

I noticed that for each dataset, Power BI maintains seven days of query log data, and the training operations is based on the 7-day of query log. How will the cache change if I haven’t use one report more than 1 month?  There is no log for the report for recent 7 days. Will the cache be deleted by then?

Question3: About the cache growth

Thanks for you mentioned that “Using automatic aggregation also does not cause the cache to keep growing”. It is the very thing that I care about. Would you mind explain some details to help me understand?

I am curiosity of the cache growth because my client wonder if the cache keeps growing so that one day the cache will be full, as both data size in backend data source and the number of reports keeps growing.

In this occasion, what will happen to reports in workspace? Should I purchase more storage space for cache by then?

Looking forward to your reply,

Bestwishes,

Eliza