Launch Deal · 50% off 1st month ·
← PL-300 study guide

Domain 1 – Prepare the Data (25–30%)

8 lessons, each ending with a practice scenario

Log in to save your progress.

  1. ✓1.1 — Connect to Data Sources, Credentials and Privacy LevelsEvery Power BI report starts with Get data in Power BI Desktop (or in the service, for dataflows and web modeling). You pick a connector, sign in, choose tables in the Navigator, and then either Load the data as it is or Transform data in the Power Query Editor.
  2. ✓1.2 — Choose Between Import, DirectQuery and Direct LakeThe storage mode decides where a table's data lives and when queries reach the source. You set it per table in Model view (Properties Advanced Storage mode).
  3. ✓1.3 — Create and Modify ParametersA parameter is a named value that Power Query steps can use in place of a hard-coded value. Parameters make it easy to point the same report at another server, filter a large source, or let the service change a value without editing the file.
  4. ✓1.4 — Profile and Clean the DataBefore shaping data, you check what's actually in it. Power Query's data profiling tools are on the View tab of the Power Query Editor.
  5. ✓1.5 — Data Types, Column Transformations and GroupingThe data type controls storage, sorting, which DAX functions work, and how visuals summarize the column. Set types deliberately rather than trusting the automatic Changed Type step.
  6. ✓1.6 — Pivot, Unpivot, Transpose and Semi-Structured DataPower BI models work best with long, narrow tables: one row per fact, one column per attribute. Many sources (Excel reports especially) arrive wide, with a column per month or per region. These transforms reshape them.
  7. ✓1.7 — Fact and Dimension Tables, Keys, Reference and DuplicatePower BI models perform best and are easiest to use as a star schema: fact tables in the middle, dimension tables around them, each linked by a one-to-many relationship.
  8. ✓1.8 — Merge and Append Queries, and Configure Data LoadingBoth have an …as New option that creates a new query instead of changing the current one. Join kinds: Left outer (default), Right outer, Full outer, Inner, Left anti, Right anti.
Domain recapQuick overview of all lessons
  • Connect to data sources and shared semantic models, and manage credentials and privacy levels
  • Choose between Import, DirectQuery and Direct Lake, and use parameters
  • Profile data and resolve inconsistencies, nulls, quality issues and import errors
  • Shape data in Power Query: types, columns, grouping, pivoting, semi-structured data
  • Build fact and dimension tables with keys, and use reference, duplicate, merge and append queries
  • Configure data loading for each query
Next domain

Domain 2: Model the data →