This guide covers all official objectives for the PL-300 certification, structured into focused chapters from data preparation to visualization and governance.
This guide works best as a loop: read a chapter, test yourself with practice questions, look up unfamiliar terms in the glossary, then move to the next chapter.
18 chapters covering every exam objective. Each chapter includes key concepts, exam tips, common traps, comparison tables, and a 5-question quiz at the end.
Start Chapter 1Free timed and untimed practice with instant feedback and full explanations. Pick 10–120 questions per session. Filter by domain to drill your weak areas.
Go to practice testEvery PL-300term defined and searchable. Use it when a chapter mentions a concept you haven't seen before or want a quick refresher on.
Browse glossaryExam blueprint, domain weights, passing score, duration, cost, and registration links. Start here if you're new to this certification.
View exam guideIntroduction to Power BI and the PL-300 Exam
Objective 1.1 · Identify key features and capabilities of Power BI
Connecting to Data Sources
Objective 1.2 · Connect to data sources including relational, non-relational, and cloud-based
Data Profiling and Cleaning in Power Query
Objective 1.3 · Profile data to understand its structure and quality
Transform Data with Power Query Editor
Objective 1.4 · Transform data using Power Query Editor (e.g. merging, splitting, pivoting)
Advanced Data Transformation Techniques
Objective 1.5 · Apply advanced transformations including M language basics, conditional columns, and custom functions
Data Loading and Storage Modes
Objective 1.6 · Choose between Import, DirectQuery, and Dual storage modes
Data Modeling Fundamentals
Objective 2.1 · Design a data model that supports analysis and reporting
Relationships and Calculated Columns
Objective 2.2 · Create and manage relationships and calculated columns
DAX Measures and Time Intelligence
Objective 2.3 · Create measures using DAX including time intelligence functions
Advanced DAX and Query Optimization
Objective 2.4 · Optimize DAX queries and model performance using best practices
Row-Level Security (RLS)
Objective 2.5 · Implement row-level security to restrict data access
Creating Visuals and Designing Reports
Objective 3.1 · Select and create appropriate visualizations for reports
Adding Interactivity: Slicers, Filters, and Bookmarks
Objective 3.2 · Configure interactivity with slicers, filters, and bookmarks
Publishing and Dashboards in Power BI Service
Objective 3.3 · Publish reports and create dashboards in the Power BI service
Managing Workspaces and Content
Objective 4.1 · Create and manage workspaces, apps, and content packs
Deployment Pipelines and Lifecycle Management
Objective 4.2 · Implement deployment pipelines and manage the content lifecycle
Security and Governance in Power BI
Objective 4.3 · Configure permissions, data sensitivity labels, and audit logs
Performance Optimization and Monitoring
Objective 4.4 · Monitor usage, performance, and optimize Power BI environments
Free PL-300 practice questions with full explanations. Test what you learn chapter by chapter.
PL-300 Practice Questions