Composite models explained
Composite models let Power BI combine Import and DirectQuery data within the same semantic model. They can solve genuine reporting challenges, particularly where large datasets or near real-time requirements are involved. But they also introduce complexity around performance, relationships, security and maintenance. This guide explains when composite models make sense, when they do not, and what to consider before using one.