Learn about aggregations in Power BI in this 57-minute conference talk from PASS Data Community Summit. Explore different table storage modes, set up aggregation tables, and configure them to improve query performance. Discover the benefits of aggregations, understand import and direct query modes, and compare their differences. Dive into dual storage mode, direct query, and aggregation tables, including their limitations. Follow along with a demonstration on connecting to Power BI, managing server timings, and handling aggregations. Address topics such as failing aggregations, multiple aggregations, and role-level security. Gain valuable insights to enhance your Power BI skills and optimize data analysis workflows.
Overview
Syllabus
Introduction
Agenda
Aggregations
Benefits
Power BI
Power BI Model
Import Mode
Direct Query Mode
Import vs Directory
Power BI Desktop
Dual Storage Mode
Direct Query
Aggregation Tables
Aggregation Limitations
Background Information
Demo
Connecting to Power BI
Server Timings
Managing Aggregations
Failing Aggregations
Multiple Aggregations
Role Level Security
Recap
Conclusion
Taught by
PASS Data Community Summit
