Study guide

About the PL-300 Exam

Microsoft Power BI Data Analyst PL-300

Track your progress as you read

Finished sections get a check mark.

1 Introduction

About the PL-300 Exam The Power BI Ecosystem

2 Chapter 1: Get or Connect to Data

1.1 Data Source Types and Connections 1.2 Storage Modes: Import, DirectQuery, and Direct Lake 1.3 Data Source Settings and Parameters

3 Chapter 2: Profile and Clean the Data

2.1 Data Profiling in Power Query 2.2 Resolving Errors, Nulls, and Data Quality Issues 2.3 Data Types and Type Detection

4 Chapter 3: Transform and Load the Data

3.1 Column Transformations and Data Types 3.2 Grouping, Aggregating, Pivoting, and Unpivoting 3.3 Merge Queries, Append Queries, and Relationship Keys 3.4 Query Folding and Load Performance

5 Chapter 4: Design and Implement a Data Model

4.1 Star Schema Design 4.2 Relationships, Cardinality, and Cross-Filter Direction 4.3 Table and Column Properties 4.4 Calculated Columns and Calculated Tables

6 Chapter 5: Create Model Calculations with DAX

5.1 DAX Fundamentals and Measures 5.2 The CALCULATE Function 5.3 Time Intelligence Measures 5.4 Statistical Functions, Semi-Additive Measures, and Calculation Groups 5.5 Essential DAX Patterns and Functions Reference

7 Chapter 6: Optimize Model Performance

6.1 Performance Analyzer and DAX Query View 6.2 Model Size Reduction and Cardinality Management 6.3 DAX Optimization Patterns

8 Chapter 7: Create Reports

7.1 Visual Types and Selection 7.2 Visual Formatting and Conditional Formatting 7.3 Copilot in Power BI Reports 7.4 Report Page Configuration and Slicers

9 Chapter 8: Enhance Reports for Usability and Storytelling

8.1 Bookmarks, Navigation, and Drillthrough 8.2 Sorting, Selection Pane, Mobile Layout, and Accessibility 8.3 Export Settings and Automatic Page Refresh

10 Chapter 9: Identify Patterns and Trends

9.1 The Analyze Feature and AI Visuals 9.2 Using Copilot to Summarize the Semantic Model 9.3 Advanced Analytics Patterns

11 Chapter 10: Create and Manage Workspaces and Assets

10.1 Workspaces, Apps, and Content Distribution 10.2 Subscriptions, Alerts, and Semantic Model Refresh 10.3 Dashboards and Advanced Distribution

12 Chapter 11: Secure and Govern Power BI Items

11.1 Row-Level Security (RLS) 11.2 Sensitivity Labels, Item Access, and Governance 11.3 Deployment Pipelines and Content Lifecycle

About the PL-300 Exam

Key Takeaways Explain This Topic AI

The PL-300 is the Microsoft Power BI Data Analyst Associate certification exam.

Exam format: 40-60 questions in 100 minutes with a passing score of 700/1000.

Four domains: Prepare Data (25-30%), Model Data (25-30%), Visualize & Analyze (25-30%), Manage & Secure (15-20%).

Question types include multiple choice, drag-and-drop, case studies, and hot area selections.

Certification is valid for one year and renewable for free via Microsoft Learn assessments.

Last updated: October 2026

Quick Answer: The PL-300 is a 40-60 question, 100-minute Microsoft exam with a 700/1000 passing score and $165 fee. It certifies you as a Microsoft Certified: Power BI Data Analyst Associate — validating skills in data preparation, modeling, visualization, analysis, and governance using Power BI. No prerequisites are required, and the certification renews annually for free.

The PL-300: Microsoft Power BI Data Analyst exam is the industry-standard certification for professionals who transform raw data into actionable business insights using Microsoft Power BI. As the successor to the DA-100 exam, the PL-300 reflects the latest capabilities of the Power BI platform, including Copilot AI integration, Direct Lake storage mode, and Microsoft Fabric connectivity.

Exam Overview

  • Detail Information
  • Full Name Exam PL-300: Microsoft Power BI Data Analyst
  • Certification Microsoft Certified: Power BI Data Analyst Associate
  • Administered By Pearson VUE (online and in-person)
  • Questions 40-60 (includes unscored pretest items)
  • Time Limit 100 minutes
  • Passing Score 700 out of 1000
  • Cost $165 USD (varies by region)
  • Prerequisites None required
  • Validity 1 year (renewable for free)

Who Should Take the PL-300?

The PL-300 is designed for Power BI data analysts who deliver actionable insights by working with available data and applying domain expertise. Ideal candidates:

  • Provide meaningful business value through easy-to-comprehend data visualizations
  • Enable others to perform self-service analytics
  • Collaborate with business stakeholders to identify requirements
  • Work with analytics engineers and data engineers to identify and acquire data
  • Are proficient with Power Query and DAX (Data Analysis Expressions)
  • Exam Structure by Domain

The PL-300 covers four major skill areas with the following weights:

  • Domain Weight Key Skills
  • Prepare the Data 25-30% Connect to sources, clean data, transform and load
  • Model the Data 25-30% Design models, write DAX, optimize performance
  • Visualize and Analyze 25-30% Create reports, enhance usability, identify trends
  • Manage and Secure 15-20% Workspaces, apps, RLS, sensitivity labels
  • Question Types

The PL-300 uses several question formats:

  • Format Description
  • Multiple Choice Select the best answer from 4-5 options
  • Multiple Select Choose all correct answers from a list
  • Drag-and-Drop Arrange items in the correct order or match pairs
  • Case Study Read a business scenario and answer 4-7 related questions
  • Hot Area Click the correct area on a screenshot or diagram
  • Build List Select and order steps to complete a task

Important: Case study sections cannot be revisited once completed. Budget approximately 12-15 minutes per case study.

2026 Exam Updates

As of April 20, 2026 , the PL-300 objectives were updated to include:

  • Direct Lake as a storage mode option alongside DirectQuery and Import
  • Copilot in Power BI for creating narrative visuals and report pages
  • Calculation groups as a DAX modeling technique
  • Visual calculations using DAX within report visuals
  • DAX query view for performance analysis
  • Enhanced emphasis on sensitivity labels and data governance
  • Certification Benefits

Earning the Power BI Data Analyst Associate certification provides:

  • Industry recognition — Power BI is used by 200,000+ organizations worldwide
  • Career advancement — Certified professionals earn 15-20% more on average

Pathway to advanced certs — Foundation for DP-600 (Fabric Analytics Engineer) and DP-700 (Fabric Data Engineer)

  • Free annual renewal — No retake needed, just complete a free Microsoft Learn assessment
  • Digital badge — Shareable Credly badge for LinkedIn and resumes
  • Study Timeline Recommendation
  • Experience Level Study Hours Timeline
  • Regular Power BI user (1+ years) 30-40 hours 2-3 weeks
  • Some Power BI experience 40-60 hours 4-6 weeks
  • New to Power BI 60-80 hours 6-8 weeks
  • How Scaled Scoring Works

Microsoft does not publish the exact number of scored questions, the live-versus-pretest split, or the official time allowance for the PL-300 — the widely cited figures of roughly 40–60 questions in about 100 minutes come from candidate reports, not from Microsoft. What Microsoft does confirm is that the passing score is 700 on a 1 to 1,000 scale and that scores are scaled , not raw percentages.

Scaling means each question contributes a weighted number of points based on its difficulty, and a small number of unscored pretest items are mixed in so Microsoft can trial future questions. Because of this, 700 does not equal answering 70% of items correctly — on a harder form you may pass with fewer correct answers, and on an easier form you may need more. Treat 75–80% on quality practice tests as a safer internal target than a bare 70%.

Renewal and the Certification Path

The Power BI Data Analyst Associate certification expires one year after you earn it, but renewal is free : within the six-month window before expiration you complete an online, unproctored renewal assessment on Microsoft Learn . The renewal assessment is shorter than the exam, can be retaken, and keeps your certification continuously current as the platform evolves.

Exam Tip: The PL-300 is the only exam required to earn the associate certification — there is no second exam or experience requirement. After passing, it is a recognized foundation for DP-600 (Fabric Analytics Engineer Associate) and broader Microsoft Fabric credentials.

On the Exam

The PL-300 exam frequently tests:

  • Practical application of Power Query transformations and DAX formulas
  • Choosing the correct storage mode (Import, DirectQuery, Direct Lake) for a scenario
  • Data modeling best practices including star schema design
  • Report design choices that maximize usability and accessibility
  • Security implementation including RLS and sensitivity labels

PL-300 Exam Domain Weights (%)