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:

«

Prev

1

/

1

Next

»

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

«

Prev

1

/

1

Next

»