What is the PL-300 Certification?
Microsoft Power BI Data Analyst (PL-300) is the associate-level Microsoft certification for data professionals who use Power BI. It validates your ability to connect to data, transform it, model it, build reports, and publish insights to Power BI Service.
Unlike the beginner-level certifications, PL-300 tests hands-on skills. You need to be comfortable with Power Query, DAX, and Power BI Desktop to pass.
Exam facts: - Cost: $165 USD - Passing score: 700 out of 1000 - Format: 40 to 60 questions plus performance-based tasks - Duration: 100 to 120 minutes - Recommended experience: 2 or more months using Power BI
Exam Domains
| Domain | Weight |
|---|---|
| Prepare the Data | 15 to 20% |
| Model the Data | 30 to 35% |
| Visualise and Analyse the Data | 25 to 30% |
| Deploy and Maintain Assets | 20 to 25% |
Data modelling is the largest section — invest the most time here.
Domain 1: Prepare the Data
Power Query Editor is where data transformation happens. Key skills:
- Connect to data sources (Excel, SQL, SharePoint, web, REST APIs)
- Remove duplicates, filter rows, handle nulls
- Split columns, merge queries, append queries
- Change data types correctly
- Create custom columns using M language expressions
- Use Power Query parameters for dynamic data sources
- Enable query folding (let the database do the transformation work, not Power Query)
Query folding is important for performance. It means Power Query pushes transformation steps back to the data source as native queries. Not all steps support folding. The exam tests whether you know which transformations break query folding.
Domain 2: Model the Data (Largest Domain)
Star Schema: The recommended data model structure for Power BI: - Fact tables: Large tables containing measurements (sales transactions, orders) - Dimension tables: Smaller lookup tables (customers, products, dates, regions) - Relationships: One-to-many from dimension to fact table
A proper star schema dramatically improves report performance and DAX calculation simplicity.
Calculated Columns vs Measures
| Calculated Column | Measure | |
|---|---|---|
| Calculated at | Import/refresh time | Query time |
| Stored in | Data model (uses memory) | Not stored |
| Row context | Yes — calculated row by row | No (aggregate context) |
| Filter context | Not initially | Yes |
| Best for | Row-level classification, relationships | KPIs, aggregations, ratios |
Key rule: Use measures for aggregations and KPIs. Use calculated columns only when you need a value per row for use in a relationship or filter.
Essential DAX Functions
- CALCULATE([measure], filter) — Most powerful function. Changes the filter context of a calculation
- SUMX(table, expression) — Iterator: sums an expression evaluated row by row
- RELATED(column) — Retrieves a value from the related table (like VLOOKUP)
- ALL(table or column) — Removes filters from a column or table
- FILTER(table, condition) — Returns a filtered table for use inside other functions
- DIVIDE(numerator, denominator, [alternate]) — Safe division that handles divide-by-zero
- DATEADD(dates, intervals, period) — Time intelligence: calculate values from a previous period
Time Intelligence (heavily tested): Power BI has built-in time intelligence functions that require a properly marked Date table: - TOTALYTD — Year-to-date total - SAMEPERIODLASTYEAR — Compare to same period last year - PREVIOUSMONTH / PREVIOUSYEAR — Previous period values
For time intelligence to work correctly: your Date table must cover every date in the data, have a continuous date range, and be marked as a Date table.
Domain 3: Visualise and Analyse the Data
Choosing the right visual: - Bar/Column chart: Compare categories (which product sold most?) - Line chart: Trends over time - Scatter chart: Correlations between two measures - Map visual: Geographic data - Card/KPI: Single metric highlights - Matrix: Cross-tabulation with drill-down - Funnel: Sequential stage conversion rates
Filters, Slicers, and Interactions: - Filters panel: applies permanently, not visible to end users - Slicers: visible on-page filters, users can interact - Cross-filtering: clicking one visual filters others by default - Edit interactions: change which visuals filter which — or disable filtering entirely
Accessibility features: - Alt text on all visuals - Tab order for keyboard navigation - Sufficient colour contrast - Avoid relying on colour alone to convey meaning
Row-Level Security (RLS): RLS restricts data access at the row level based on the user's role. Configure in Power BI Desktop with DAX filter rules, then publish and assign users to roles in Power BI Service.
Example: A sales manager can only see data for their own region. RLS applies the filter automatically when they view the report.
Domain 4: Deploy and Maintain Assets
Power BI Service Structure: - Workspaces: Containers for reports, datasets, dashboards (separate from My Workspace) - Apps: Packaged collections of reports and dashboards published for end users - Dashboards: Collections of pinned tiles from multiple reports - Reports: Interactive multi-page views built from a single dataset - Datasets (Semantic Models): The data foundation that reports are built on
Sharing and permissions: - Workspace roles: Admin, Member, Contributor, Viewer - App audience: who can view the published app - Share individual reports with specific users or groups - Row-Level Security controls what data users can see
Refresh and gateways: - Datasets must be refreshed to show new data - For data sources behind a corporate firewall, an On-premises data gateway is required - Configure scheduled refresh in Power BI Service - Data gateway modes: Standard (shared, multiple users) vs Personal (single user, less secure)
Best Resources for PL-300
- Microsoft Learn PL-300 learning path (free, official) — start here
- Guy in a Cube YouTube channel (free) — the best free Power BI content on the internet
- SQLBI (dax.guide and sqlbi.com) (free) — the definitive resource for DAX
- Udemy: Wyn Hopkins PL-300 course — highly rated, includes practice exams
- Power BI Desktop (free download) — build real reports as you study
Exam Strategy
PL-300 has performance-based tasks — you interact with an actual Power BI environment in the exam. This makes hands-on practice essential, not optional.
Build this into your study routine: - Connect to at least 3 different data source types - Build a proper star schema from scratch - Write at least 10 DAX measures from memory - Configure RLS and verify it works - Publish a report to Power BI Service and share it
The exam will ask you to choose the most appropriate DAX function or data model structure for a given scenario. If you have done it in practice, you will recognise the right answer instantly.