What is composite model in Power BI?

< 1 min read

A composite model in Power BI allows combining multiple storage modes in a single report.
It supports Import mode, DirectQuery, and Dual mode together.
This gives flexibility between performance and real-time data access.
In one project, historical data was imported for fast reporting.
Live transactional data was connected using DirectQuery for near real-time updates.
Dual mode was used for shared dimensions like Date and Product.
Composite model helps balance performance, scalability, and freshness requirements.

Power BI Essentials