PL-300 Practice Test: Sample Questions With Answers
· 8 min read
A good PL-300 practice test covers the four skill areas Microsoft lists for the exam: prepare the data, model the data, visualize and analyze the data, and manage and secure Power BI. Below are 12 practice questions across those areas, with answers and explanations at the end. They are written for this blog on Brightline Supply Co. sample data. They are not real exam questions, and they will not tell you what is on your exam. Use them to find gaps, then fill those gaps in Power BI Desktop.
Microsoft also offers an official practice assessment for PL-300, linked from the exam's study guide on Microsoft Learn. Take it too: it is the closest thing to the real question style.
What the PL-300 exam covers
PL-300 is the exam for the Microsoft Certified: Power BI Data Analyst Associate certification. Microsoft's study guide lists these skill areas (skills measured as of April 20, 2026):
| Skill area | Weight | Examples of what it includes |
|---|---|---|
| Prepare the data | 25–30% | Connect to sources, profile and clean data, transform and load, merge and append, create keys |
| Model the data | 25–30% | Relationships, cardinality and cross-filter direction, date table, role-playing dimensions, DAX measures, CALCULATE, time intelligence, performance |
| Visualize and analyze the data | 25–30% | Choose and format visuals, slicing and filtering, bookmarks, drillthrough, tooltips, accessibility, Copilot features |
| Manage and secure Power BI | 15–20% | Workspaces, apps, publishing, dashboards, gateways, scheduled refresh, row-level security, sensitivity labels |
According to Microsoft's exam scoring page, a score of 700 or greater is required to pass. The study guide also notes that associate certifications expire annually and can be renewed with a free online assessment on Microsoft Learn.
The exam fee, the number of questions and the time allowed are not listed here on purpose. They vary by country and change over time. Check the official PL-300 exam page and study guide for current details before you book.
The sample data
The questions use a small model: a Sales fact table with eight order lines, and Products, Customers and Date dimensions related one-to-many to Sales. Only completed orders count as revenue: 612.10 out of 744.10 across all statuses. Completed revenue by month is January 220.50, February 112.10, March 279.50. If you want to build it yourself, the tables are in the DAX practice exercises.
Practice questions
Prepare the data
1. Brightline's targets file has one row per region and one column per month (Region, Jan, Feb, Mar). You need one row per region and month. What do you do in Power Query?
A. Transpose the table B. Select Region, then Unpivot Other Columns C. Pivot the Region column D. Group By Region
2. Customers has a one-to-many relationship to Sales. After the CRM export adds a second row for CustomerID 1002 ("Lakeside Studios " with a trailing space), the refresh fails. What is the best fix?
A. Change the relationship to many-to-many B. Set the cross-filter direction to Both C. In Power Query, trim the text columns and then remove duplicates on CustomerID D. Make the relationship inactive
3. You receive orders for 2025 and 2026 as two queries with the same columns. You need one Sales table. Which operation?
A. Merge queries B. Append queries C. Create a relationship between the two tables D. Reference the first query
Model the data
4. Sales has OrderDate and ShipDate. You need revenue by order date and by ship date using one Date table. What do you set up?
A. Two active relationships from Date to Sales B. One active relationship to OrderDate, one inactive to ShipDate, and USERELATIONSHIP in the ship-date measure C. A bidirectional relationship to ShipDate D. A LOOKUPVALUE column on Sales for the ship month
5. A report shows COUNTROWS ( Products ) by Customers[Region], and every region shows 6. The Products to Sales relationship is one-to-many, single direction. You need the number of distinct products sold in each region without changing the model. Which measure?
A. COUNTROWS ( Products )
B. DISTINCTCOUNT ( Sales[ProductID] )
C. COUNTROWS ( ALL ( Products ) )
D. COUNT ( Products[ProductID] )
6. Which of these should be a calculated column rather than a measure?
A. Margin % B. An Order Size band ("Bulk" for 6 or more units, else "Standard") that users pick in a slicer C. Year-to-date revenue D. Percent of total revenue
7. Revenue is defined as below. What does Completed Revenue return on a card?
Revenue =
SUMX ( Sales, Sales[Quantity] * Sales[UnitPrice] * (1 - Sales[DiscountPct]) )
Completed Revenue =
CALCULATE ( [Revenue], Sales[Status] = "completed" )A. 744.10 B. 612.10 C. 660.10 D. 132.00
8. This measure shows 100% on every row of a table with Products[Category] on the rows. Which change fixes it?
% of Total =
DIVIDE ( [Completed Revenue], CALCULATE ( [Completed Revenue], ALL ( Products[ProductName] ) ) )A. Replace DIVIDE with the / operator
B. Replace ALL ( Products[ProductName] ) with REMOVEFILTERS ( Products[Category] )
C. Wrap the measure in KEEPFILTERS
D. Change the relationship to Both
9. With 'Date'[Month] on the rows, what does this measure return for February?
Completed Revenue YTD =
TOTALYTD ( [Completed Revenue], 'Date'[Date] )A. 112.10 B. 220.50 C. 332.60 D. 612.10
Visualize and analyze the data
10. Users on a summary page want to right-click a customer and open a detail page filtered to that customer. Which feature?
A. Bookmarks B. Drillthrough C. Sync slicers D. Report page tooltips
Manage and secure Power BI
11. Each regional manager should see only rows for their own region in the same report. What do you implement?
A. One copy of the report per region B. A page-level filter on Region C. Row-level security roles with a DAX filter on Customers[Region] D. A separate workspace per region
12. A published semantic model gets its data from a SQL Server database inside Brightline's office network. Scheduled refresh fails. What is most likely needed?
A. An on-premises data gateway B. A bidirectional relationship C. DirectQuery instead of Import D. A higher refresh frequency
Answers and explanations
- B. Unpivot Other Columns keeps Region and turns each month column into rows of Attribute (month) and Value (target). It also keeps working when a new month column is added.
- C. The "one" side of a relationship needs unique keys, and a refresh that loads a duplicate into it fails. Trim first so the names are clean, then remove duplicates on the key column. Removing duplicates on all columns without trimming would keep both rows, because of the trailing space. Many-to-many hides the problem. See relationships and star schema and the Power Query tutorial.
- B. Append stacks rows (like SQL UNION ALL). Merge adds columns from another table (like a join).
- B. This is a role-playing dimension. Only one relationship between two tables can be active, and USERELATIONSHIP activates the other one inside CALCULATE. Covered in RELATED and USERELATIONSHIP.
- B. The Region filter reaches Sales but not Products. DISTINCTCOUNT on the fact table counts products sold: West 4, East 2, North 2.
- B. Slicers need columns, and the band belongs to each row. Ratios, YTD and percent of total must be measures so they recompute for every filter.
- B. CALCULATE keeps only completed lines. 744.10 is every status, 660.10 adds the refunded order, and 132.00 is the cancelled and refunded orders.
- B. The visual filters Category, so the denominator must remove the Category filter. Removing a ProductName filter that is not there changes nothing. More in ALL, ALLEXCEPT and ALLSELECTED.
- C. January 220.50 plus February 112.10.
- B. Drillthrough passes the selected value as a filter to a target page.
- C. RLS filters data per role in one report and one model. A page filter can be changed by users and is not security.
- A. The Power BI service needs a gateway to reach data sources on a private network.
If you got 10 or more right, move on to timed practice with the official assessment. If you missed questions 7 to 9, spend a week on CALCULATE and the date table before anything else: DAX CALCULATE explained and how to create a date table.
A short PL-300 study guide plan
- Read the official study guide and tick each skill you have done in Power BI Desktop at least once.
- Build one model end to end: import and clean, relate, write measures, build a report, publish, set up refresh and RLS.
- Practise DAX on data with known answers. Write each measure, then check one cell by hand.
- Take the official practice assessment, note every wrong answer, and redo that task in Desktop.
- Revisit the service topics (workspaces, apps, gateways, sensitivity labels). Analysts who only use Desktop often lose points there.
Common mistakes
Studying from "dumps" or AI-generated question banks
Collections that claim to be real exam questions are against the exam rules, and they are often wrong. AI-generated question sets have a different problem: they mix in features that have been renamed or removed and present plausible but incorrect answers with confidence. A common one is an AI answer that says you can build a dashboard in Power BI Desktop. You cannot: dashboards exist only in the Power BI service. How to spot it: check each explanation against the official documentation or by doing it in Power BI Desktop.
Memorising answers instead of doing the task
Scenario questions change the details. If you have only memorised "unpivot", a question about a slightly different layout catches you out. Do each task once with your own hands.
Skipping the smaller areas
Manage and secure Power BI has the lowest weight, but it is also the area many analysts have least hands-on time with.
FAQ
Is there a free PL-300 practice test?
Yes. Microsoft offers a practice assessment for PL-300, linked from the study guide on Microsoft Learn. The 12 questions on this page are another free set, written for practice only.
How hard is the PL-300 exam?
It depends on how much hands-on Power BI work you have done. People who have built and published a few complete models usually find the questions familiar. People who have only watched videos often struggle with DAX and the service topics.
What is the passing score for PL-300?
Microsoft's exam scoring page says a score of 700 or greater is required to pass. Check the official page for the current details on question count and time allowed.
Is a Power BI certification worth it for a data analyst?
It shows employers you have covered the whole workflow, from data prep to security. It does not replace a portfolio. Pair it with a project you can explain and with practice on Power BI interview questions.
Practise this on a realistic dataset
Solve it yourself on one company's data, with instant feedback that points at what's wrong without giving away the answer.
Try “Connect order lines to products” →