Flat tables or models in Power BI? Which one should I choose and why?
Should you work with flat wide tables or create models in Power BI? In this video, I walk you through the advantages of creating models instead of flattening your tables.
Watch the tutorial:

Links to the mentioned resources
I recommend you to check the Vertipaq series to understand more:



What is Vertipaq and how does it work? Part 1: Data compression

Why is Vertipaq so fast? Part 2: Columnar database

Why is Vertipaq so fast? Part 3: Segment Elimination

DAX Fridays! #126: Understand the Formula Engine and Storage Engine to optimize your DAX queries

Was this helpful?
Reader Interactions