PL-300 exam topics
The PL-300 exam (Microsoft Certified: Power BI Data Analyst Associate) covers 4 domains and 30 topics. This page lists all of them with the weight of each domain, so you can see what the exam tests and where most of the marks are.
Domains and weights
| Domain | Weight | Topics |
|---|---|---|
| Domain 1: Prepare the data | 25–30% | 8 |
| Domain 2: Model the data | 25–30% | 8 |
| Domain 3: Visualize and analyze the data | 25–30% | 8 |
| Domain 4: Manage and secure Power BI | 15–20% | 6 |
Domain 1: Prepare the data · 25–30%
- Connect to Data Sources, Credentials and Privacy Levels
Every 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.
- Choose Between Import, DirectQuery and Direct Lake
The 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).
- Create and Modify Parameters
A 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.
- Profile and Clean the Data
Before 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.
- Data Types, Column Transformations and Grouping
The 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.
- Pivot, Unpivot, Transpose and Semi-Structured Data
Power 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.
- Fact and Dimension Tables, Keys, Reference and Duplicate
Power 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.
- Merge and Append Queries, and Configure Data Loading
Both 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 2: Model the data · 25–30%
- Configure Table and Column Properties
Properties are set in Model view (or the Data view and Column tools ribbon) in the Properties pane. They don't change the data. They change how fields behave and look for everyone who builds reports on the model.
- Relationships, Cardinality, Cross-Filter Direction and Role-Playing Dimensions
A relationship lets filters on one table reach another. You create it by dragging one column onto another in Model view, or with Manage relationships.
- Create a Common Date Table
Almost every model needs one shared date table related to every fact table's date column. It gives consistent years, quarters, months and fiscal periods across facts, and DAX time intelligence functions (lesson 2.6) rely on it.
- Measures, Calculated Columns and Calculated Tables
DAX can create three kinds of objects. Choosing the right one is a frequent exam question. Calculated, Context, Stored in the model, Responds to slicers, Use on axes, slicers, rows of a matrix, Example.
- Single Aggregation Measures and the CALCULATE Function
Use an iterator when the value must be computed per row first: Revenue = SUMX(Sales, Sales[Quantity] Sales[Unit Price]). This avoids storing a calculated column.
- Time Intelligence and Semi-Additive Measures
Time intelligence functions shift or extend the dates in the filter context. They need a proper date table (lesson 2.3): contiguous, related to the fact table, and marked as a date table.
- Statistical Functions, Quick Measures and Calculation Groups
Rank products by sales, keeping the rank stable when a product is filtered out of the visual.
- Optimize Model Performance
Slow reports usually come from one of three places: a model that's too big, inefficient DAX, or too many or too heavy visuals. The exam expects you to find the cause with the right tool, then fix it.
Domain 3: Visualize and analyze the data · 25–30%
- Select, Format and Theme Visuals
Start from the question the visual must answer. Compare categories, Trend over time, Trend plus a second measure on another scale, Parts of a whole, few categories, Hierarchical parts of a whole, How a starting value becomes an ending value, Stages that narrow down (sales pipeline), Relationship between two measures, Ranking changes over time, One key number, A number against a target, Exact values, cross-tab, Location, Explain why a value changed.
- Conditional Formatting, Slicing and Filtering
Available on tables, matrices, cards, charts' colors and titles. In a table or matrix: Format Cell elements, or right-click a field in the Values well Conditional formatting.
- Use Copilot to Create Pages, Suggest Content, Write Narratives and Summarize the Model
Copilot in Power BI uses the semantic model to build report pages and answer questions in natural language. It's on the exam in four places: creating a page, suggesting content, the narrative visual, and summarizing the semantic model.
- Configure Report Pages, Paginated Reports and Visual Calculations
Format page (click an empty part of the canvas) controls: Page information, Canvas settings, Canvas background, Wallpaper, Filter pane; Right-click a page tab to Hide it. Hidden pages still work as drillthrough and tooltip targets, and readers reach them through buttons.; View Page view options: Fit to page, Fit to width, Actual size.; Set the canvas to a taller custom size for a page readers should scroll.
- Bookmarks, Custom Tooltips, Navigation and the Selection Pane
A bookmark saves the current state of a page: filters and slicers, sort order, drill location, which visuals are visible, and spotlight/focus mode. View Bookmarks Add.
- Visual Interactions, Drillthrough, Sync Slicers and Sorting
Selecting a data point in one visual affects the others on the page. Select the source visual, then Format Edit interactions. Each other visual shows icons.
- Export Settings, Mobile Layout, Personalization, Accessibility and Automatic Page Refresh
File Options and settings Options Current file Report settings Export data sets what readers can export from visuals in the service: Summarized data, data with current layout and underlying data, Summarized data and data with current layout, No data.
- Identify Patterns and Trends: Analyze, Grouping, AI Visuals, Forecasting and Anomalies
Right-click a data point in a bar, column or line chart and choose Analyze: Explain the increase / Explain the decrease: compares the point with the previous one and shows which categories contributed most to the change, as visuals you can add to the report.; Find where this distribution is different: looks for fields where the selected point's distribution differs most from the others.
Domain 4: Manage and secure Power BI · 15–20%
- Create Workspaces, Publish Items and Build Dashboards
A workspace is a container in the Power BI service for semantic models, reports, dashboards, dataflows and (in Fabric) other items. My workspace is personal and for your own work only; shared workspaces are for team content.
- Configure Apps and Choose a Distribution Method
An app packages selected content from one workspace for a broad audience of readers. Each workspace can publish one app. Creating or updating it (Create app / Update app in the workspace, Admin or Member role, or Contributor if the workspace allows it).
- Subscriptions, Data Alerts, and Promoting or Certifying Content
A subscription emails a snapshot of a report page, a whole report, a dashboard or a paginated report on a schedule. Choose Subscribe on the item in the service.
- Identify When a Gateway Is Required and Configure Scheduled Refresh
The Power BI service runs in the cloud. An on-premises data gateway is the bridge it uses to reach data it can't reach directly. SQL Server, Oracle, file shares, Excel or CSV files on a local or network drive, A source in an Azure virtual network or behind a private endpoint, Azure SQL Database, Synapse, Fabric, Dataverse, Salesforce, SharePoint Online, OneDrive for work or school, Web sources open to the internet.
- Workspace Roles, Item-Level Access and Semantic Model Permissions
Access in Power BI works at three levels: the workspace (roles), the item (sharing and direct access), and the data (RLS, lesson 4.6).
- Row-Level Security and Sensitivity Labels
RLS filters the rows a user can see, through roles defined in the semantic model. It's the only report-level way to make sure two people looking at the same report see different data.
PL-300 exam facts
| Questions | About 40–60 |
|---|---|
| Time limit | 100 minutes |
| Passing score | 700 on a scale of 1–1,000 |
| Exam fee | $165 USD (varies by country) |
| Certification valid for | 12 months, renewable free online |
| Delivery | Pearson VUE, online proctored or at a test centre. Microsoft Learn is open during the exam |
| Retakes | After 24 hours the first time; longer waits for later retakes |
Study these topics
- Read the free PL-300 study guide: one lesson per topic above, each with its sources in Microsoft Learn.
- See how to prepare for PL-300 for a study plan ordered by domain weight.
- Test yourself with the free 10-question PL-300 mock test, or the full PL-300 practice exam.
Skillmarked is independent and not affiliated with Microsoft. The topic list follows the public exam outline; check the official exam page for the current version before you book.