Star schema
A star schema is a data-modeling pattern with central fact tables related to surrounding dimension tables. PL-300 covers building fact and dimension tables and modeling relationships.
All PL-300 Terms
Power BI
Power BI is Microsoft's business-analytics platform for preparing, modeling, visualizing, and sharing data.
Power Query
Power Query is the Power BI data-connection and transformation engine used to get, clean, and shape data.
DAX
DAX (Data Analysis Expressions) is the formula language for creating measures and calculated columns in Power BI models.
Measure
A measure is a DAX calculation evaluated in the context of a report, such as a sum or time-intelligence value.
CALCULATE
CALCULATE is a core DAX function that evaluates an expression in a modified filter context.
Semantic model
A semantic model (formerly dataset) is the Power BI data model of tables, relationships, and measures that reports query.
Star schema
A star schema is a data-modeling pattern with central fact tables related to surrounding dimension tables.
Relationship
A relationship connects tables in a Power BI model by matching keys, with a cardinality and cross-filter direction.
DirectQuery
DirectQuery is a Power BI storage mode that queries the source at report time instead of importing data.
Import mode
Import mode is a Power BI storage mode that loads a copy of the data into the model for fast queries.
Row-level security
Row-level security (RLS) restricts which rows a user can see in a Power BI report based on their identity or role.
Sensitivity label
A sensitivity label is a Microsoft Purview classification applied to Power BI content to enforce protection and compliance.
Copilot in Power BI
Copilot in Power BI is an AI assistant that generates report pages, narrative visuals, and semantic-model summaries from natural language.