Composite Models in Power BI

In Composite Models in Power BI, Greg Trzeciak shows you how to combine multiple data sources and storage modes to build flexible, high-performing Power BI solutions. You’ll learn what composite models are, why they matter, and how they differ from traditional single-source models. This course breaks down the key concepts behind Import, DirectQuery, and Dual storage modes so you can choose the right approach based on speed, freshness, and maintainability. You’ll also build a composite model step by step, connecting to SQL Server, reviewing model performance, and introducing aggregation tables to improve query speed. Greg walks through relationship tuning, expanding the model safely, and where DAX fits into composite scenarios. By the end, you’ll understand how to design composite models that balance performance and real-time needs, while avoiding common pitfalls like broken query folding and unexpected relationship behavior.