Overview of Composite Models

Composite models in Power BI allow users to blend data from different sources and connection types, such as Direct Query and Import mode, into a single model. This approach enables the combination of existing live connections and additional data sources without losing relationships or creating entirely separate datasets. For instance, users can combine a live connection to a semantic model with an Excel file, enhancing flexibility in report generation and data analysis. However, understanding the complexities and performance implications of working with composite models is crucial, as interacting with multiple connection modes could lead to slower query performance and unexpected data behavior.