PL-300 practice questions — Microsoft Power BI Data Analyst

The exam

What PL-300 tests

PL-300 validates the ability to deliver insights with Power BI: preparing data with Power Query, modelling it and writing DAX calculations, building and enhancing reports, and managing and securing Power BI workspaces and content.

Who it is for

Built for associate-level candidates

Data analysts who work with business stakeholders to identify requirements and with analytics and data engineers to acquire data, then use Power BI to prepare, model, visualize and secure it. You should be proficient in Power Query and Data Analysis Expressions (DAX).

What it covers

The official domains, weighted as the exam weights them.

Your readiness map in the app is organised the same way, so what you see here is exactly what you study against.

Prepare the data
28%
Model the data
28%
Visualize and analyze the data
27%
Manage and secure Power BI
17%

What Preppio gives you

Signal, not vibes.

1,097 questions

Across every domain above, in 5 formats: concept, scenario, ordering, multi-select, matching. Each one explains why the right answer is right and every distractor wrong.

A readiness map

Per domain, whether you are ready, weak, or not started — the same domains and weights as the exam itself.

Winston

Your study partner. He tracks where you are weak and drills exactly that, instead of serving you what you already know.

Try one

One of each format PL-300 uses, from the same bank.

Answer on the page. The explanation appears when you submit; use Next to move through the formats.

Sample 1 · Concept

You are configuring a Power Query in Power BI Desktop for Adventure Works. The query filters an Orders table to return only orders placed in the last N days, where N must be easily adjustable by report maintainers without opening the Advanced Editor. You need to implement this requirement. What should you do?

Pick one, then submit.

Sample 2 · Scenario

You are finalizing a semantic model for Contoso. A column named CustomerEmail in the Customer table is used only to look up customer records in Power Query and is never used in visuals, filters, or relationships. You need to prevent the column from appearing in the field list for report authors while retaining its value for future use. What should you do?

Pick one, then submit.

Sample 3 · Ordering

You have a Power BI Desktop report for Tailwind Traders. The report contains a matrix visual that displays Product Category on rows, Month on columns, and a measure named Total Sales as values. You need to add a visual calculation to the matrix that displays the running total of Total Sales across the Month columns for each Product Category. Which three actions should you perform in sequence?

Drag an item onto another to swap them, or use the arrows, then submit.

1In the formula bar, enter Running total = RUNNINGSUM([Total Sales], COLUMNS), and then commit the calculation.
2Select the matrix visual on the report canvas.
3On the Home ribbon, select New calculation to open the visual calculations edit mode.

Sample 4 · Multi-select

Select all that apply: You manage a Power BI app at Fabrikam, Inc. that is distributed to 200 employees in the Sales department. You update two reports in the underlying workspace and need the changes to reach all app users with minimal administrative effort. Which two actions should you perform?

Select all that apply, then submit.

Sample 5 · Matching

Match each business requirement at Contoso, Ltd. to the storage mode that satisfies it:

Pick up a response below, then click a prompt to place it.

Response pool — click to pick up

1 of 5

Study links

Official material

Official Study Guide (Microsoft Learn)learn.microsoft.com Free Practice Assessmentaka.ms Power BI Documentationlearn.microsoft.com Exam Sandboxaka.ms

FAQ

The things people ask about PL-300

How many questions are on the PL-300 exam, and how long is it?

50 questions in 100 minutes.

What score do you need to pass PL-300?

70%, a scaled score of 700.

What does PL-300 cover?

4 domains, weighted as the exam weights them: Prepare the data (28%), Model the data (28%), Visualize and analyze the data (27%) and Manage and secure Power BI (17%). Your readiness map in the app is organised by the same domains, so what you study against is what the exam tests.

What question formats does PL-300 use?

Five formats: concept, scenario, ordering, multi-select and matching. The practice questions use every one of them, and the sample on this page shows one of each.

Is PL-300 free on Preppio.ai?

PL-300 is on the Single, Dual and All Access plans. You start on the free tier and add it from the plan picker inside the app. Three fundamentals exams (AZ-900, CLF-C02 and CDL) are always free, and the sample on this page is free to try.

Where do the PL-300 practice questions come from?

Every question is generated from the exam's published objectives, then checked for accuracy, answer key and explanation before it is served. Nothing is copied from any exam, questions rotate by how often they have been seen, and they are retired when the objectives change.

PL-300Microsoft Power BI Data Analyst