A composite model is a Power BI model that combines different data connection modes or sources in the same semantic model.
Composite model
A composite model is a Power BI model that combines different data connection modes or sources in the same semantic model.
Quick facts about composite models
Combines storage modes
A composite model can use more than one storage mode, such as Import and DirectQuery.
Supports mixed sources
It can bring together data from different sources or models when a report needs a more flexible structure.
Useful for complex reporting
Composite models can help when some data should be imported, while other data should stay connected to the source.
Needs careful design
Because composite models combine different behaviors, they require planning around performance, relationships and calculations.
When one connection mode is not enough
Composite models are useful when a Power BI report needs data that does not all fit into one simple model pattern. Some tables may work best when imported for speed, while others may need to stay closer to the source through DirectQuery. Composite models can support scenarios such as:
- Combining imported data with DirectQuery tables
- Connecting reporting data from several sources
- Extending an existing semantic model
- Balancing report performance with fresher source data
This gives report creators more flexibility, but also more responsibility. The model needs to be tested carefully so filters, relationships and measures behave as expected.
Flexibility behind the report should not create confusion for users
A composite model can help solve complex data needs, but the user should not have to understand that complexity. Customers, partners or internal teams should be able to open a report and trust the numbers, without thinking about which tables are imported and which ones query the source.
In Power BI, composite models are part of the data and modeling layer. Skald BI helps with the delivery layer, making it easier to share finished Power BI reports through a secure branded portal for customers, partners and internal users.
Use cases
See how different types of organisations use Skald BI to share Power BI securely with employees, customers and partners.
Contact us
Try Skald BI for free
Whether you’re looking for expert advice, tailored
solutions, or have a specific inquiry, reach out to
our team.
No set up. Live fast.
Support contact
Follow us
Frequently asked questions
What is a composite model in Power BI?
What is a composite model used for?
A composite model is used when a report needs more flexibility than a single connection mode can provide, such as combining imported data with DirectQuery tables.
Is a composite model the same as DirectQuery?
No. DirectQuery is one connection mode. A composite model can include DirectQuery together with other storage modes or data sources.
Why do composite models need careful design?
Composite models can affect performance, relationships, filtering and calculations, so they need to be tested before reports are shared widely.
How do composite models relate to Skald BI?