Power BI · Chapter 50
Power BI: Composite Models — Import, DirectQuery, Dual, Aggregations
Mix Import and DirectQuery safely — Dual, aggregation hit/miss, Live vs composite, hybrid SQL fact sketch.
Fictional sample data for learning. Brands belong to their owners. Numbers are made up for class.
In this chapter
- Compare Import, DirectQuery, Dual, and Live connection.
- State composite model limits at a practical level.
- Explain Dual mode relationship behaviour.
- Describe aggregation hit vs miss.
- Know when Live connection still wins.
- Sketch a hybrid SQL fact + Import dimension model.