Video unavailable
SQLBits 2022
A-GREAT-gations - Unleash the true power of Power BI!
Create blazing fast reports over large amounts of data!
How many times have you struggled to import your large dataset into Power BI, because of its size? How many times have you wished that your report works faster for these datasets?
What if I tell you that Power BI offers you an out-of-the-box feature to accelerate the queries over huge amounts of data, even when they reside outside of Power BI?
In this session, we will examine one of the most powerful features in Power BI - aggregations! We'll cover user-defined aggregations, understand aggregation precedence and considerations related to RLS. You'll also learn about Automatic aggregations, one of the latest Power BI performance enhancements.
During the demos, you'll learn how to create and manage aggregations, and how to check if the Power BI queries really take advantage of hitting the aggregated tables.