Aggregations are one of the most important optimization methods for managing large datasets in Power BI. Combined with Direct Query storage mode, they allow big datasets to be analyzed efficiently by answering high level analytical queries quickly from memory while sending more detailed queries back to the source database.

In this session, you will learn about aggregations, different table storage modes, how to set up aggregation tables and configure them to improve query performance.