ExamSprintLab

Free PL-300 sample questions with answers

Updated October 9, 2026

Here are five free PL-300 sample questions, one or more from each skill area, with the answer and the reasoning behind it. Try each one before opening the answer. These are original scenario questions written against the official skills outline, not questions from the real exam.

Question 1. You have two Power Query queries, Sales2024 and Sales2025. They have identical columns and each holds one year of orders. You need a single table that contains every order from both years. What should you use?

  • A. Merge Queries
  • B. Append Queries
  • C. Group By
  • D. Pivot Column
Show answer

Answer: B

Append Queries stacks the rows of one query under another when the columns match, which is what combining two years of the same structure needs. Merge Queries joins two tables side by side on a key and adds columns, not rows. Group By summarises rows into fewer rows. Pivot Column turns values of a column into new column headings.

Want more questions like this? Full PL-300 practice tests →

Question 2. The Sales table has OrderDate and ShipDate columns. Both must be analysed against the same Date table, so a report can show sales by order date and, in another visual, by ship date. What is the correct approach?

  • A. Create two active relationships from Sales to Date
  • B. Make the single relationship bi-directional
  • C. Keep one relationship active, make the other inactive and use USERELATIONSHIP in a measure
  • D. Merge OrderDate and ShipDate into one column in Power Query
Show answer

Answer: C

Power BI allows only one active relationship between two tables. Keep OrderDate active, create the ShipDate relationship as inactive, and write a measure that activates it with USERELATIONSHIP. Two active relationships are not allowed. A bi-directional filter changes filter propagation, not which column is used. Merging the two columns in Power Query destroys the distinction between the two dates.

Want more questions like this? Full PL-300 practice tests →

Question 3. A matrix shows Total Sales by Product Category. You need a measure that returns the total sales of all categories on every row, so that you can calculate each category's share of the total. Which expression should the measure use?

  • A. CALCULATE([Total Sales], ALL('Product'[Category]))
  • B. CALCULATE([Total Sales], VALUES('Product'[Category]))
  • C. CALCULATE([Total Sales], KEEPFILTERS('Product'[Category]))
  • D. SUM(Sales[Amount])
Show answer

Answer: A

ALL removes the filter on the Category column inside CALCULATE, so every row returns the grand total, which is the denominator you need. Without any change, the plain measure is filtered by the row’s category. VALUES keeps the current category, so it changes nothing. KEEPFILTERS preserves existing filters instead of removing them.

Want more questions like this? Full PL-300 practice tests →

Question 4. Users of a summary page want to right-click a region in a bar chart and jump to a detail page that shows only that region. What should you configure?

  • A. A bookmark for each region
  • B. Sync slicers on both pages
  • C. A report page tooltip
  • D. A drillthrough page with the region field as the drillthrough filter
Show answer

Answer: D

Drillthrough lets a user right-click a data point and navigate to a target page that is filtered by that point. You set the drillthrough field on the detail page. A bookmark stores a view state and does not pass the selected value. Sync slicers keep slicer selections consistent across pages. A tooltip page appears when hovering and does not navigate.

Want more questions like this? Full PL-300 practice tests →

Question 5. Regional sales managers must see only the rows for their own region in a published report. The managers have Viewer access to the workspace. You define a role in Power BI Desktop with a DAX filter on the Region table and publish the model. What must you do next for the filter to apply to each manager?

  • A. Give each manager the Contributor role on the workspace
  • B. Add each manager, or a group containing them, to the role on the semantic model in the Power BI service
  • C. Create a visual-level filter for each region on every page
  • D. Publish the report to a second workspace
Show answer

Answer: B

Row-level security roles take effect only for people who are members of the role. After publishing you add the users or groups to the role in the semantic model security settings in the Power BI service. Creating a second workspace or changing the visual filter does not apply the role. Admin, Member and Contributor roles bypass RLS, so giving managers more access would defeat it.

Want more questions like this? Full PL-300 practice tests →

How did you do?

Questions 2 and 5 catch the most people. Inactive relationships look like a modelling detail until a report needs two dates, and RLS has a service-side half that candidates forget: defining the role in Desktop does nothing until members are added in the service. If either slowed you down, read the modelling guide or the manage and secure guide.

Question 3 is worth a second look too. Filter context is the single idea behind most DAX questions, and a measure you cannot predict is a measure you will get wrong in a scenario.

What these questions have in common

None of them asks for a definition. Each describes a requirement and several options that all sound plausible, and the answer depends on one detail: rows rather than columns, only one active relationship, remove a filter rather than keep it, pass a value to a target page, add members to a role. That is how most of PL-300 reads. Train yourself to underline the constraint before looking at the options.

For a longer check, take the 20-question practice test.