Use this on a live-connected report in Power BI Desktop to bolt on a local model. Doing so turns the connection into DirectQuery and the report becomes a composite model, letting you mix in extra data such as spreadsheet tables.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Make changes to this model in context, with comparison tables and the common traps.
Terms in this definition
- Power BI Desktop
A free Windows program where authors connect to sources, shape and model data, and design reports before publishing them to the Power BI service. Dashboards are not made here.
- LSDOU
The sequence in which Group Policy is processed: the local policy first, followed by site, domain and organisational unit policies. The nearest, last-processed setting takes effect unless Enforced or Block Inheritance alters that.
- Connection
Resource that attaches a virtual network gateway to its peer, which may be an ExpressRoute circuit, a second VNet gateway (Vnet2Vnet) or a local network gateway over IPsec. Resetting it recovers a single tunnel and avoids rebooting the whole gateway.
- DirectQuery
Power BI connection mode in which reports fetch data from the source in real time; Direct Lake outperforms it.
- Composite model
A Power BI semantic model whose tables use different storage modes, for example some Import and some DirectQuery, chosen table by table. Tables in Dual mode can work either way, and Power BI picks whichever suits each query best.
Related terms
- DirectQuery for Power BI semantic models
Lets an author whose report is live-connected to a published semantic model choose Make changes to this model, turning that link into a local composite model to which their own tables and columns can be added. Tenant settings have to allow it.
- Live connection
Power BI reports can skip having a local model and instead connect straight to one already published in the Power BI service, Azure Analysis Services or SQL Server Analysis Services. Authors may still write report-level measures; editing the underlying model is possible only after converting it via Make changes to this model.