Power BI provides manual and automatic aggregations to optimize queries on DirectQuery over SQL models. Pre-aggregated tables can highly improve the performance of the storage engine at the expense of storage and increased processing time.
In this session, we introduce the concept of aggregation; we show several examples of their usage, understanding the advantages and the limitations of aggregations, intending to build a solid understanding of how and when to use the feature in data models. Eventually, we will see how to control the use of manual aggregations in DAX, which can also be used with other storage engines such as VertiPaq and DirectLake.