Composite models (Public Preview)

Note

These release notes describe functionality that may not have been released yet. To see when this functionality is planned to release, please review Summary of what’s new. Delivery timelines and projected functionality may change or may not ship (see Microsoft policy).

Composite models allow you to mix import and tabular direct query sources as well as have multiple tabular DirectQuery sources. This lets you augment your enterprise data models with imported tables.

Modelers can create a Power BI Desktop file over a DirectQuery data source, and then also add tables that are imported from another data source. To support this new model structure, we also are introducing many-to-many relationships and tables that are in dual mode, which means they can act as import or DirectQuery, depending on what other tables you add to the visuals. Power BI will then intelligently serve answers to your analyses from either the imported data or by pushing a query to the underlying datasource.