PL-300 flashcards
PL-300 · Build recall with a focused review session.
32 cards. Read the term and the definition here. The deck at the top of this page is optional.
- Query folding
- The ability of Power Query to translate transformations into a single native query executed by the source. Steps that break folding, such as adding an index, force local processing instead.
- Unpivot columns
- A Power Query transform that turns several wide columns into two columns, Attribute and Value, producing a normalized table that is easier to model and aggregate in a star schema.
- Merge vs append queries
- Merge joins two tables side by side on matching key columns using a chosen join kind. Append stacks tables vertically, aligning rows by matching column names.
- Default column profiling scope
- Power Query profiles only the first 1000 rows by default. Selecting 'Column profiling based on entire dataset' in the status bar gives accurate valid, error and distinct statistics.
- Group By All Rows
- A Group By aggregation option that returns one row per group plus a nested table column holding all detail rows, which can then be expanded or aggregated further.
- Using Locale
- A Power Query command that converts a text column to a data type under a specified culture, resolving ambiguous formats such as month/day versus day/month ordering in source files.
- Power Query parameters
- Named values typed as text, number, date or logical that can be referenced inside queries and data source paths, so one query works across development and production environments.
- Replace Errors
- A Power Query transform that substitutes a chosen value for every error cell in the selected column, whereas Remove Errors deletes the entire affected row instead.
- Star schema
- A model design where a central fact table stores keys and numeric measures while surrounding dimension tables store descriptive attributes, joined by one-to-many single-direction relationships for efficient filtering.
- CALCULATE
- The DAX function that evaluates an expression in a modified filter context. It replaces existing filters on the same columns unless the KEEPFILTERS function wraps those filters.
- USERELATIONSHIP
- A DAX function used inside CALCULATE that activates an inactive relationship for that calculation only, letting one fact table serve multiple date or dimension roles.
- Mark as date table
- A Power BI setting designating a table as the model's date table; it requires one contiguous row per date with no blanks so time-intelligence functions return correct results.
- DIVIDE
- The DAX function DIVIDE(numerator, denominator, alternate) that returns the alternate result, BLANK by default, instead of an error when the denominator is zero or blank.
- RELATED and RELATEDTABLE
- RELATED fetches a single value from the one-side table of a relationship; RELATEDTABLE returns the related many-side rows as a table for use inside iterator functions.
- Row-level security roles
- DAX table filters such as [Region] = "West" stored in the model that restrict which rows a user can query once that user is assigned to the role in the service.
- Storage modes
- Import caches an in-memory copy for fast queries; DirectQuery queries the source live; Dual can behave as either; Direct Lake reads Delta files without import or query translation.
- Measure versus calculated column
- A calculated column is evaluated at refresh and stored in memory for every row. A measure is evaluated at query time in the filter context and stores no data.
- Sync slicers
- A report setting that links slicers across pages so a selection on one page applies to matching slicers on other pages, with sync and visibility chosen per page.
- Bookmarks
- Saved snapshots of a report capturing filter and slicer state, visual visibility and the current page; they are paired with buttons to build navigation and guided storytelling.
- Drillthrough
- A feature that navigates to a separate report page filtered to the selected value of a drillthrough field, optionally keeping all filters from the originating page.
- What-if parameter
- A modeling feature that creates a table of candidate values with GENERATESERIES plus a slicer; the selected value is read in DAX with the SELECTEDVALUE function.
- Key influencers visual
- An AI visual that ranks which categorical fields most increase or decrease a chosen metric, displaying the top segments and their relative impact on that metric.
- Performance Analyzer
- A Power BI Desktop pane that logs DAX query duration, visual display time and rendering time for each visual, helping identify the slowest elements on a report page.
- Report page tooltip
- A hidden tooltip page whose visuals appear when hovering over a data point; it can contain multiple visuals and is bound through the visual's tooltip settings.
- Dashboard versus report
- A dashboard is a single-page canvas of tiles pinned from one or more reports and supports data alerts and Q&A; a report is multi-page, filterable and built in Desktop.
- Workspace roles
- Admin manages the workspace and its members, Member publishes and updates the app, Contributor creates and edits content but cannot publish the app, and Viewer is read-only.
- App audiences
- App audiences let one published app deliver different content sets to different security groups, so each group sees only the dashboards, reports and datasets intended for them.
- Deployment pipeline
- A service feature that copies workspace content through Development, Test and Production stages, using rules to change dataset parameters per stage and supporting selective deployment.
- On-premises data gateway
- A service agent installed on a network that lets the Power BI service reach on-premises sources for scheduled refresh and DirectQuery without exposing the server publicly.
- Scheduled refresh limits
- Datasets in Pro or shared capacity refresh up to 8 times per day; datasets in Premium, Premium Per User or Fabric capacity refresh up to 48 times per day.
- Promoted versus certified
- Promoted marks content as trustworthy and can be set by any author with write permission; Certified requires approval by a certifier designated by the Power BI administrator.
- Sensitivity labels
- Microsoft Purview labels applied to Power BI items that persist into exported files and can enforce encryption and restrict export to supported formats such as Excel and PDF.