PL-300 practice questions and exam guide
Every exam fact on this page was checked on Microsoft Learn on 15 November 2026. BI Data Hero is not affiliated with or endorsed by Microsoft.
The short answer
PL-300 is Microsoft's exam for the Microsoft Certified: Power BI Data Analyst Associate certification. Microsoft rates it Intermediate.
- Passing score: 700 or more on a scale of 1 to 1,000. It is a scaled score, so it may not equal 70% of the points (exam scoring).
- Time: 100 minutes, as the PL-300 certification page states (exam duration).
- Questions: most Microsoft exams have 40 to 60; Microsoft doesn't give a number for PL-300.
- Skills measured as of 20 April 2026 (study guide): Prepare the data (25 to 30%), Model the data (25 to 30%), Visualize and analyze the data (25 to 30%) and Manage and secure Power BI (15 to 20%).
- Renewal: every 12 months, through a free online assessment on Microsoft Learn (renewal).
What PL-300 measures
The study guide lists four skill areas. The weights are Microsoft's; the groups under each are the study guide's own headings.
| Skill area | Weight | What it covers |
|---|---|---|
| Prepare the data | 25 to 30% | Get or connect to data; Profile and clean the data; Transform and load the data. Includes choosing between DirectLake, DirectQuery and Import. |
| Model the data | 25 to 30% | Design and implement a data model; Create model calculations by using DAX; Optimize model performance. Includes calculation groups, and Performance Analyzer with DAX query view. |
| Visualize and analyze the data | 25 to 30% | Create reports; Enhance reports for usability and storytelling; Identify patterns and trends. Includes visual calculations, and Copilot for a narrative visual, a new report page and a summary of the semantic model. |
| Manage and secure Power BI | 15 to 20% | Create and manage workspaces and assets; Secure and govern Power BI items. Includes row-level security group membership and sensitivity labels. |
What changed on 20 April 2026: the study guide's change log marks minor changes in three skill groups: Get or connect to data, Enhance reports for usability and storytelling, and Create and manage workspaces and assets. It doesn't name the individual items. Today's list includes Copilot in reports, the choice between DirectLake, DirectQuery and Import, visual calculations and calculation groups.
How hard is PL-300?
Microsoft rates PL-300 Intermediate and publishes no pass rate, so we don't quote one. What makes it demanding is breadth: four skill areas, from Power Query and data modelling to DAX, report design and security. Microsoft doesn't say in advance which question formats an exam uses; its sample videos include multiple choice, drag and drop, build list, hot area and case studies. You can open Microsoft Learn during associate exams, but no extra time is added (Microsoft Learn during your exam).
10 PL-300 practice questions
Original questions written for BI Data Hero, not questions from the real exam.
Each one comes from the app's question bank and was checked again on Microsoft Learn on 15 November 2026. Microsoft says the same of its own practice questions: they are examples, not what you will see on the exam (practice assessments).
Question 1 · Prepare the data
An Orders table has 100 rows and a Customers table has 80, one row per customer. You merge them in Power Query with an inner join on CustomerID. 15 orders have a CustomerID that isn't in Customers. How many rows does the result have?
- A100: every order is kept
- B85: only the orders with a matching customer
- C80: one row per customer
- D180: every row from both tables
Show the answer
B. 85: only the orders with a matching customer
An inner join keeps only the rows that match in both tables. The 15 orders without a matching customer drop out, so 85 rows remain.
Skill: Merge and append queries. Source: Inner join on Microsoft Learn.
Question 2 · Prepare the data
A table has the columns Product, Jan_Sales, Feb_Sales and Mar_Sales. You select the three sales columns and unpivot them. What do you get?
- AThree tables, one for each month
- BThe columns Product, Attribute and Value, with one row per product and month
- COne row per product, with the months merged into one column header
- DThe same table, with the sales columns renamed
Show the answer
B. The columns Product, Attribute and Value, with one row per product and month
Unpivot turns the selected columns into attribute-value pairs: the column names go into Attribute and the numbers into Value, so each product becomes three rows, one per month (a month with a null value is left out). You would usually rename Attribute to Month and Value to Sales.
Skill: Pivot, unpivot, and transpose data. Source: Unpivot columns on Microsoft Learn.
Question 3 · Prepare the data
What is the main difference between refreshing a Direct Lake semantic model and refreshing an Import model?
- AThere is none: both copy all the data into memory
- BAn Import refresh copies the data into the model; a Direct Lake refresh copies only metadata, and data is loaded into memory when queries need it
- CA Direct Lake refresh is slower because it has to read OneLake
- DAn Import refresh is always faster because the data is already local
Show the answer
B. An Import refresh copies the data into the model; a Direct Lake refresh copies only metadata, and data is loaded into memory when queries need it
Import mode keeps an entire cached copy of the data in the semantic model. A Direct Lake refresh copies only metadata (called framing), which can take a few seconds; after that, only the data a query needs is loaded into memory.
Skill: Choose between DirectLake, DirectQuery, and Import. Source: Direct Lake overview on Microsoft Learn.
Question 4 · Model the data
A slicer is set to Year = 2024 and a table visual shows one row per Sales[Country]. What does this measure return on the UK row?
Country Sales % = DIVIDE ( SUM ( Sales[Amount] ), CALCULATE ( SUM ( Sales[Amount] ), ALL ( Sales[Country] ) ) )- AUK sales for all years, divided by sales for all countries and all years
- BUK sales in 2024, divided by 2024 sales for all countries: the UK's share of 2024
- CUK sales in 2024, divided by UK sales for all years
- DAlways 100%
Show the answer
B. UK sales in 2024, divided by 2024 sales for all countries: the UK's share of 2024
The numerator sees both filters: UK and 2024. In the denominator, ALL ( Sales[Country] ) removes only the filter on that column, so the year filter stays. The result is the UK's share of 2024 sales.
Skill: Use the CALCULATE function. Source: ALL function (DAX) on Microsoft Learn.
Question 5 · Model the data
A model has 50 measures, and each needs a year-to-date, quarter-to-date and month-to-date version. How many measures do you maintain without calculation groups, and what do you need with them?
- AWithout: 200 measures. With: the 50 measures plus one calculation group with three calculation items
- BWithout: 150 measures. With: the 50 measures plus three calculation groups
- CWithout: 50 measures. With: 50 measures, nothing changes
- DWithout: 53 measures. With: 3 measures
Show the answer
A. Without: 200 measures. With: the 50 measures plus one calculation group with three calculation items
Without calculation groups you keep the 50 measures and add 150 variants (50 times 3), so 200 in all. With a calculation group you keep the 50 measures and add one group with three calculation items (YTD, QTD and MTD), which apply to the model's measures through SELECTEDMEASURE().
Skill: Create calculation groups. Source: Calculation groups on Microsoft Learn.
Question 6 · Model the data
Your Sales table has an active relationship from OrderDate to the Date table and an inactive one from ShipDate. What do USERELATIONSHIP and CROSSFILTER each do?
- AThe same thing: they are interchangeable
- BUSERELATIONSHIP creates a new permanent relationship; CROSSFILTER deletes the active one
- CUSERELATIONSHIP changes the filter direction of a relationship; CROSSFILTER turns an inactive relationship on
- DUSERELATIONSHIP makes a relationship, such as the inactive ShipDate one, the one used during a CALCULATE; CROSSFILTER sets the cross-filter direction of a relationship during a CALCULATE
Show the answer
D. USERELATIONSHIP makes a relationship, such as the inactive ShipDate one, the one used during a CALCULATE; CROSSFILTER sets the cross-filter direction of a relationship during a CALCULATE
Both change a relationship only while a CALCULATE expression is evaluated; neither creates nor deletes one. USERELATIONSHIP is how one Date table plays two roles (order date and ship date). CROSSFILTER sets the direction of an existing relationship, for example None, Both or OneWay.
Skill: Implement role-playing dimensions. Source: USERELATIONSHIP function (DAX) on Microsoft Learn.
Question 7 · Visualize and analyze the data
You need the same running total of revenue on a line chart, a bar chart and a table, and you want to define it once. What do you create?
- AA visual calculation: Power BI shares it with the other visuals automatically
- BA measure in the model: a visual calculation belongs to the one visual it was created on
- CA visual calculation on each of the three visuals
- DA visual calculation, which you then copy to the other two visuals
Show the answer
B. A measure in the model: a visual calculation belongs to the one visual it was created on
Visual calculations are stored on a visual, not in the model, and Microsoft lists reuse across visuals as not available. A calculation you need on several visuals belongs in a measure, defined once in the model.
Skill: Create visual calculations by using DAX. Source: Using visual calculations on Microsoft Learn.
Question 8 · Visualize and analyze the data
A page has a bar chart by region, a monthly line chart and a card with total revenue. Clicking a region should filter the line chart but leave the card showing the overall total. What do you configure?
- ASet the line chart to Highlight and the card to Filter
- BSelect the bar chart, turn on Edit interactions, then set the line chart to Filter and the card to None
- CMove the card to another page
- DAdd a visual-level filter to the card
Show the answer
B. Select the bar chart, turn on Edit interactions, then set the line chart to Filter and the card to None
Interactions are set per source visual. With the bar chart selected, Edit interactions shows a control on every other visual on the page: Filter on the line chart shows only the clicked region, and None on the card leaves it unchanged.
Skill: Edit and configure interactions between visuals. Source: Change how visuals interact in a report on Microsoft Learn.
Question 9 · Manage and secure Power BI
A report's semantic model uses row-level security (RLS). Which statement is wrong?
- AWorkspace Viewers see only the rows their RLS role allows
- BPeople with no workspace role who use the report through an app see only the rows their RLS role allows
- CWorkspace Members see only the rows their RLS role allows
- DYou can define roles in Power BI Desktop, then assign users or security groups to them in the Power BI service
Show the answer
C. Workspace Members see only the rows their RLS role allows
RLS restricts data only for users with Viewer permission. Workspace Admins, Members and Contributors, and anyone with Write permission on the semantic model, are not filtered: a manager added as a Member sees every region. Give readers of RLS-protected content the Viewer role, or share it through an app.
Skill: Implement row-level security roles. Source: Row-level security (RLS) with Power BI on Microsoft Learn.
Question 10 · Manage and secure Power BI
Who can certify a semantic model or report?
- AAnyone with a Pro licence
- BOnly the workspace Admin
- COnly people the Fabric administrator has authorised to certify content
- DAny workspace Member or Contributor
Show the answer
C. Only people the Fabric administrator has authorised to certify content
Certification needs authorisation: a Fabric administrator turns it on in the tenant settings and names the security groups whose members may certify, and a certifier also needs write permission on the item. Promotion is different: anyone with write permission on an item can promote it.
Skill: Promote or certify Power BI content. Source: Endorsement overview on Microsoft Learn.
Exam tips from Microsoft's own pages
- Answer every question: there's no penalty for guessing, and some questions are unscored without telling you which (how exams are scored).
- Take breaks with care: once you start a break you can't go back to the questions you saw before it, and the exam clock keeps running (breaks).
- Use Microsoft Learn during the exam only for what you can find quickly: it's open to you, but no extra time is added (Microsoft Learn during your exam).
- Try the exam sandbox first, so the interface holds no surprises, and take Microsoft's Practice Assessment.
- If you don't pass, you can retake the exam after 24 hours; after that, 14 days apply between attempts, with at most five attempts in 12 months (retake policy).
How BI Data Hero maps to PL-300
BI Data Hero is a Power BI practice game for iPhone and Android. Its 648 timed challenges hold 882 questions in 40 chapters across five regions, each with a source on Microsoft Learn. Each region mainly practises one skill area:
| Region in the app | Main skill area | Challenges (questions) |
|---|---|---|
| Shaping RiversPower Query | Prepare the data | 133 (205) |
| Model GrovesData modelling | Model the data | 128 (164) |
| Measure PeaksDAX | Model the data | 145 (199) |
| Sight TowersVisualisation | Visualize and analyze the data | 111 (111) |
| Governance CitadelPower BI service | Manage and secure Power BI | 131 (203) |
The mapping is by main topic: Model Groves' chapter on storage modes, for example, practises the DirectLake, DirectQuery and Import choice that the study guide puts under Prepare the data. The app covers DirectLake and calculation groups in depth; visual calculations and building reports with Copilot get only a few questions so far, so use Microsoft Learn for those. A rapid-fire challenge asks ten quick questions, which is why some regions have more questions than challenges.
Ten introduction challenges are free; one in-app purchase unlocks the rest. No account, and your answers stay on your device.
Microsoft's own PL-300 resources
- Power BI Data Analyst Associate certification
- PL-300 study guide, with the skills measured
- Practice Assessment, on Microsoft's AI Skills Navigator
- Exam sandbox, to try the exam interface
- Exam scoring and score reports
- Exam duration and exam experience
PL-300 questions people ask
What is the passing score for PL-300?
700 or more on a scale of 1 to 1,000. Microsoft notes that this is a scaled score, so it may not equal 70% of the points (exam scoring).
How long is the PL-300 exam?
The PL-300 certification page gives 100 minutes. Microsoft lists 100 minutes for associate exams without labs and 120 minutes for exams that may contain labs, and doesn't publish which exams contain labs (exam duration).
How many questions are on PL-300?
Microsoft doesn't give a number for PL-300. It says most Microsoft certification exams contain 40 to 60 questions, and that the number can vary (exam duration and experience).
How often do I renew the certification?
Every 12 months. Renewal is free: you pass an online assessment on Microsoft Learn during the six months before your certification expires (renewing your certification).
Are these real exam questions?
No. The practice questions on this page and in the app are original questions written for BI Data Hero and checked against Microsoft Learn. They are not questions from the real exam.
