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:
Subscribe to my channel
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