Live Connection & Composite Models

Power BI · Getting Data

Theory

A live connection connects a report to an existing model instead of building a new one: a published Power BI semantic model or an Analysis Services model. The report has no Power Query and no tables of its own; all tables, relationships and measures come from the shared model, though you can add report-level measures. This is how one certified model feeds many reports.

A composite model combines storage modes or sources in one model, for example imported Customers with a DirectQuery Sales table, or a published semantic model extended with your own local Targets table. When you are live-connected to a Power BI semantic model, choosing 'Make changes to this model' converts the connection into a DirectQuery link to that model so you can add tables. Tables can also be set to Dual so they serve both imported and DirectQuery queries.

Why we use it

Live connections stop every analyst from rebuilding the same model, so everyone uses the same definition of Total Sales. Composite models add flexibility when one source or one storage mode is not enough.

When to use it

Use a live connection when a governed shared model already has what you need. Use a composite model when you must add local data to a shared model or mix Import and DirectQuery. Avoid composite designs when one simple Import model would do; they add complexity.

How it works

  1. Need a new report
  2. Does a shared semantic model already have the data? Yes: Use a live connection to it. No: Build your own Import model.
  3. Need extra local data on top? Yes: Make changes to this model (composite). No: Keep the pure live connection.
  4. Add report-level measures
  5. Report built on governed data

Syntax

Live: Home → Get data → Power BI semantic models → pick model → Connect
Extend: Modeling → Make changes to this model (creates a composite model)
Storage mode per table: Model view → Properties → Storage mode

Example

1. Connect to the certified 'Sales Model' semantic model (live connection).
2. Add a report measure: Sales per Order = DIVIDE([Total Sales], DISTINCTCOUNT(Sales[OrderID]))
3. Need region targets that are not in the shared model? Choose 'Make changes to this model'.
4. Import a local Targets(Region, Target) table and compare it with sales:
   Region Target = CALCULATE(SUM(Targets[Target]), TREATAS(VALUES(Sales[Region]), Targets[Region]))
5. The report is now a composite model: shared model via DirectQuery + local imported Targets.

Key points

Power BI topics

Power BI Introduction

Getting Data

Power Query (Data Transformation)

Data Modeling

DAX (Data Analysis Expressions)

Data Visualization

Dashboards & Reports

Power BI Service

Advanced Features

Projects & Case Studies

Interview & Certification

Advanced DAX & Time Intelligence

T
Tech Town
Log InSign Up Free
Home SQL Python DSA Power BI Snowflake Databricks Spark Gen AI Practice Problems Contest Blog

Power BI Dashboards & DAX

Learn data visualization and interactive dashboards step-by-step. Click any topic in the sidebar to open it right here.

{{ sectionCount }}
Sections
{{ topicCount }}
Topics
Free
Forever
Hands-on practice Practice DAX Online 250 business scenarios on a star schema — write a measure and compare your visual with the expected one. Start practising →
Section {{ sec.num }}

{{ sec.label }}

Power BI  /  {{ current.sectionLabel }}  /  {{ current.name }}

{{ current.name }}

Theory

{{ current.def }}

Why we use it

{{ rich.why }}

When to use it

{{ rich.when }}

Diagram

{{ rich.dg.caption }}

{{ tb.title }}
{{ c.v }}
{{ rich.dg.op }}
➜
{{ rich.dg.output.title }}
{{ c.v }}
{{ nd.label }}
{{ nd.sub }}
{{ nd.label }}
{{ nd.sub }}
{{ rich.dg.left.title }}
{{ it }}
{{ rich.dg.right.title }}
{{ it }}
On screen — where to click

{{ rich.ui.title }}

{{ u.text }}
  1. {{ st.n }}{{ st.text }}
{{ rich.ui.title }}
{{ u.text }}
Flowchart — how it works
{{ nd.text }}
{{ nd.text }}
◇ {{ nd.text }}
Yes → {{ nd.yes }}
No → {{ nd.no }}
Syntax / Where to find it
{{ current.syntax }}
Example
{{ current.example }}
What You'll Learn — click to check off
  • {{ pt.mark }} {{ pt.text }}

Share this topic