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

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

DomainWeightTopics
Domain 1: Prepare the data25–30%8
Domain 2: Model the data25–30%8
Domain 3: Visualize and analyze the data25–30%8
Domain 4: Manage and secure Power BI15–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%

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

QuestionsAbout 40–60
Time limit100 minutes
Passing score700 on a scale of 1–1,000
Exam fee$165 USD (varies by country)
Certification valid for12 months, renewable free online
DeliveryPearson VUE, online proctored or at a test centre. Microsoft Learn is open during the exam
RetakesAfter 24 hours the first time; longer waits for later retakes

Study these topics

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.