Where Power BI Desktop users see every table, column and relationship in the model at once, draw new relationships, set up hierarchies and adjust table settings like storage mode.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Model view in context, with comparison tables and the common traps.
Terms in this definition
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.
- 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.
- Event
Table in Log Analytics where entries from Windows event logs are kept.
- Set
Secret permission in Key Vault for writing secrets; some older material refers to it as Create.
- LIKE
Compares strings with a pattern that can contain the % and _ wildcards. Because it only understands character patterns, searching big volumes of text this way is much slower than using full-text search.
- Storage mode
Set separately on each table of a Power BI semantic model: Import copies data in, DirectQuery asks the source at query time, Direct Lake reads Delta tables in OneLake directly, and Dual can work either way.
Related terms
- Display folders
A property set in the Properties pane of Model view that organises fields, measures for example, into folders within the Data pane. Using a backslash in the name produces nested folders.
- Model explorer
Choosing Model at the top of the Data pane in Model view opens this outline of everything a semantic model contains, from its tables and measures to roles, perspectives and calculation groups. Settings that apply to the whole model, Discourage implicit measures among them, are changed here too.