Category: Data Modeling
31
Mar
In the Power BI whirlpool – understanding circular dependencies!
by Nikola
1 Comment
Circular dependency error is one of the most annoying things in Power BI data modeling! Learn why this is happening and how to avoid it
02
Mar
How I transformed Excel “monster” into Power BI “beauty”!
by Nikola
No Comments
How would you call going from 380 tables in 18 Excel sheets, to one table on a single report page in Power BI?! Magic? Miracle?...
02
Feb
Hybrid tables in Power BI: extending beyond time-related scenarios!
by Nikola
2 Comments
Hybrid tables are one of the most powerful features in Power BI! And, it's not (just) about separating "hot" and "cold" data...You can basically leverage...
29
Jan
Cardinality – Your Majesty!
by Nikola
2 Comments
Do you know who is the biggest "enemy" for the optimal data model size? Meet the Cardinality, and learn how to boost the report performance...
11
Jan
Killing me softly…Bi-directional relationships in Power BI!
by Nikola
3 Comments
You've heard that bi-directional relationships are "evil"? Is it true? Check why it's not (100%) true and how to avoid potential "road to hell"
20
Dec
Hybrid tables in Power BI – The ultimate guide!
by Nikola
9 Comments
Import mode and DirectQuery within the same table??? Yes, with the latest Hybrid tables features in Power BI, it's possible to get the best from...
16
Dec
Welcome to Power BI theatre: Role-Playing Dimensions!
by Nikola
4 Comments
Two "actors" for two "roles" vs one "actor" for two "roles"? Learn which approach is better when it comes to data modeling in Power BI
18
Nov
Power BI Performance Tuning Cheatsheet!
by Nikola
6 Comments
Download the cheatsheet that will help you fine tune your Power BI reports!
26
Sep
Auto Page Refresh in Power BI – Everything you need to know!
by Nikola
8 Comments
Did you know that Power BI can automatically refresh your report page? Did you know there are two different types of auto refresh? Learn everything...
05
Sep
3 reasons to use views instead of tables in Power BI!
by Nikola
9 Comments
When using a relational database as the data source for Power BI solutions, most report creators choose to take an easier path - import the...