thinQmaster Virtual testing partner Adaptive practice exams that find your weak spots and drill them. Every answer explained. From $69
Enroll

thinQmaster

Find your exam

Five questions free, before you decide.

Step 1 · choose a vendor

In one of our camps? Your practice exams come with the tuition — they are on your study page already.

Data & Analytics · Advanced

Composite Model

A Power BI model that combines storage modes, such as Import and DirectQuery tables, or that chains to other published semantic models.

Definition

Composite models let large facts stay in DirectQuery while dimensions use Import or Dual. Aggregation tables in Import mode can answer summary queries quickly.

Exam tip

Set dimension tables to Dual when they relate to both Import and DirectQuery tables.

Related terms