PL-300: Microsoft Power BI Data Analyst is the exam for Microsoft Certified: Power BI Data Analyst Associate, one of the most requested certifications for data analyst, MIS and BI roles in India. It tests Power Query, data modelling, DAX, report design, and sharing and securing content in the Power BI service. The current skills list (from 20 April 2026) includes Copilot in Power BI, Direct Lake and visual calculations.
This guide follows Microsoft's study guide: all four skill areas with weights, the DAX you need, a 6-week plan with a practice project, and 20 original practice questions.
Quick facts (Microsoft Learn, November 2026)
| Item | Detail |
|---|---|
| Exam | PL-300: Microsoft Power BI Data Analyst |
| Certification | Microsoft Certified: Power BI Data Analyst Associate |
| Time | 100 minutes; proctored; may include interactive components |
| Passing score | 700 |
| Renewal | Every 12 months, free online assessment |
| Languages | English, Japanese, Chinese (Simplified and Traditional), Korean, German, French, Spanish, Portuguese (Brazil), Italian |
| Practice | Free Practice Assessment on AI Skills Navigator |
| Price | Set by the country where you take the exam |
Read the official PL-300 study guide before booking.
Who should take PL-300?
- Freshers aiming for data analyst, BI analyst or MIS roles.
- Excel power users and SQL reporting developers moving to Power BI.
- Business and operations analysts who build dashboards for managers.
Microsoft expects you to be proficient in Power Query and DAX. Learn basic SQL and Excel first. Many Hyderabad openings combine Power BI with SQL and Python; see the live jobs for freshers.
Skills measured and weights
| Skill area | Weight |
|---|---|
| Prepare the data | 25–30% |
| Model the data | 25–30% |
| Visualize and analyze the data | 25–30% |
| Manage and secure Power BI | 15–20% |
1. Prepare the data (25–30%)
- Connect: data sources or a shared semantic model; credentials and privacy levels; Direct Lake vs DirectQuery vs Import; parameters.
- Profile and clean: column statistics and quality; nulls and inconsistencies; import errors.
- Transform and load: data types; new and transformed columns; group and aggregate; pivot, unpivot and transpose; semi-structured data (JSON) to tables; fact and dimension tables; reference vs duplicate queries; merge and append; keys for relationships; load settings.
| Storage mode | Use when |
|---|---|
| Import | Data fits in memory and refreshes on a schedule; fastest visuals |
| DirectQuery | Data must stay in the source or be near real time; slower visuals |
| Direct Lake | Data is in Fabric OneLake (Delta tables); near-Import speed without copying |
2. Model the data (25–30%)
- Model design: table and column properties; role-playing dimensions (Order Date and Ship Date); cardinality and cross-filter direction; a shared date table; calculated columns vs calculated tables.
- DAX: simple aggregations;
CALCULATE; time intelligence; basic statistics; semi-additive measures (balances); quick measures; calculation groups. - Performance: remove unneeded rows and columns; Performance Analyzer and DAX query view; reduce granularity.
Total Sales = SUM ( Sales[Amount] )
Sales LY = CALCULATE ( [Total Sales], SAMEPERIODLASTYEAR ( 'Date'[Date] ) )
YoY % = DIVIDE ( [Total Sales] - [Sales LY], [Sales LY] )
Hyderabad Sales = CALCULATE ( [Total Sales], Store[City] = "Hyderabad" )
Closing Balance =
CALCULATE ( SUM ( Account[Balance] ), LASTDATE ( 'Date'[Date] ) ) -- semi-additive3. Visualize and analyze (25–30%)
- Reports: choosing and formatting visuals; themes; conditional formatting; slicers and filters; Copilot to create report pages, suggest content and write narrative visuals; paginated reports; visual calculations.
- Usability and storytelling: bookmarks, tooltips, interactions, navigation, sorting, sync slicers, Selection pane, drillthrough, export settings, mobile layouts, personalised visuals, accessibility and automatic page refresh.
- Patterns: Analyze feature; grouping, binning and clustering; AI visuals; reference lines, error bars and forecasting; outliers and anomalies; Copilot summaries of the semantic model.
4. Manage and secure Power BI (15–20%)
- Workspaces and items: workspaces and apps; publishing; dashboards; choosing a distribution method; subscriptions and data alerts; promoting and certifying content; when a gateway is needed; scheduled refresh.
- Security and governance: workspace roles; item-level and semantic-model access; row-level security roles and group membership; sensitivity labels.
-- Row-level security role "Regional Manager" on the Store table
[Region] = LOOKUPVALUE ( Managers[Region], Managers[Email], USERPRINCIPALNAME () )6-week study plan with a practice project
Build one project from start to finish: a retail sales dashboard for a chain of stores in Hyderabad, Bengaluru and Chennai, using a public sample dataset or data you generate yourself.
| Week | Focus | Project step |
|---|---|---|
| 1 | Power Query: connect, profile, clean | Load sales CSVs and a product Excel file; fix types and nulls |
| 2 | Star schema, relationships, date table | Fact Sales with Product, Store, Customer and Date dimensions |
| 3 | DAX basics, CALCULATE, time intelligence | Sales, margin, YoY and running totals |
| 4 | Visuals, drillthrough, bookmarks, tooltips, Copilot | Executive overview page plus a store drillthrough page |
| 5 | Service: workspaces, apps, refresh, gateways, RLS, labels | Publish; RLS so each regional manager sees only their region |
| 6 | Performance Analyzer, Practice Assessment twice | Tune slow visuals; book the exam |
Put the finished project on GitHub with screenshots. See our GitHub portfolio guide.
20 practice questions with answers
These are original practice questions written for this guide, not exam questions.
1. Data must be refreshed every 15 minutes from a large SQL database and visuals can be a little slower. Which storage mode?
DirectQuery.
2. Your data already lives in Fabric OneLake as Delta tables. Which mode avoids copying it while staying fast?
Direct Lake.
3. A month column has values spread across 12 columns. Which transformation fixes it?
Unpivot columns.
4. You need customer details added to each sales row from another query. What do you use?
Merge queries.
5. January and February sales files have the same columns. How do you combine them?
Append queries.
6. Sales has Order Date and Ship Date, both linked to one Date table. What is this called?
A role-playing dimension (one active and one inactive relationship, or two date tables).
7. Which DAX function changes the filter context of a measure?CALCULATE.
8. You need last year's sales for the same period. Which function?SAMEPERIODLASTYEAR inside CALCULATE (with a marked date table).
9. Account balances must not be summed across months. What kind of measure is needed?
A semi-additive measure, for example the balance on the last date.
10. You want the same YTD, QTD and MTD logic for many measures without copying DAX. What do you use?
Calculation groups.
11. Should a value that changes with slicer selections be a calculated column or a measure?
A measure. Calculated columns are computed at refresh and do not respond to filters.
12. A report page is slow. Which tool shows which visual takes longest?
Performance Analyzer.
13. Users click a store and need a detail page for that store only. What do you configure?
Drillthrough.
14. You want a button that switches a page between chart view and table view. What do you use?
Bookmarks (with the Selection pane and a button).
15. A pixel-perfect invoice that prints across many pages is required. Which report type?
A paginated report.
16. Each regional manager must see only their region's data. What do you implement?
Row-level security roles, with users or groups assigned in the service.
17. Data comes from an on-premises SQL Server and must refresh daily in the service. What is required?
An on-premises data gateway and a scheduled refresh.
18. Business users should get a curated, read-only set of reports. What do you share?
A Power BI app from the workspace.
19. Confidential HR reports must carry a label that follows exported files. What do you apply?
A sensitivity label (Microsoft Purview Information Protection).
20. You want Power BI to write a short text summary of what a page shows. What do you use?
Copilot to create a narrative visual.
After PL-300
- Move into engineering with DP-700 (Fabric Data Engineer).
- Practise with Microsoft Fabric interview questions and data engineering interview questions.
- Read the data engineer career path.
Cloud Soft Solutions in Ameerpet, Hyderabad trains SQL, Power BI, Python and data engineering with real-time projects. See the data engineering and AI/ML course and all courses.
📞 Call +91 96660 19191 · WhatsApp · Flat No. 513, 5th Floor, Nilagiri Block, Aditya Enclave, Ameerpet, Hyderabad
Frequently Asked Questions
How long is the PL-300 exam?
100 minutes. It is proctored and may include interactive components.
What is the passing score for PL-300?
700.
What are the PL-300 skill areas?
Prepare the data (25–30%), model the data (25–30%), visualize and analyze the data (25–30%), and manage and secure Power BI (15–20%).
Does PL-300 include Copilot?
Yes. Since 20 April 2026 the skills include using Copilot to create report pages, suggest content, write narrative visuals and summarise the semantic model.
How often must PL-300 be renewed?
Every 12 months, with a free online renewal assessment.
Is there a free practice test for PL-300?
Yes. Microsoft offers a free Practice Assessment on AI Skills Navigator.
