Home Certifications Pricing FAQ Partners Blog

·EN·DE·FR·ES·PT

Microsoft · PL-300 · Associate

Microsoft Power BI Data Analyst (PL-300) — Practice Questions and Mock Exam

The PL-300 certification validates skills in preparing, modeling, visualizing, and analyzing data using Microsoft Power BI.

Practice for free Try a practice question first

Try a practice question first Practice for free

Start practicing PL-300 free Buy PL-300 access for $29.99

50Questions per Pass-IT mock exam

100minPass-IT mock exam time limit

Official PL-300 exam: 700 out of 1000 points to pass.

Checked against Microsoft · August 2026 · Current exam version

Try Pass-IT

See what learning with Pass-IT is like.

Answer a PL-300 sample question and read the explanation with its source. Right here, with no sign-up.

Model the data1 / 5

A Power BI semantic model can have only one active relationship between any two tables at a time.

AlexFull explanation from Alex

In Power BI, only one relationship between any two tables can be active at a time. When multiple relationships exist between two tables, Power BI Desktop sets one as active and the rest as inactive. The active relationship is used automatically in DAX calculations and filter propagation. To use an inactive relationship in a specific measure, use the USERELATIONSHIP() function within a CALCULATE expression. This design prevents ambiguity in cross-filter direction and ensures predictable query results. Best practice: use a star schema with clear, single active relationships. (Ref: Microsoft Learn — Create and manage relationships in Power BI Desktop)

Sourcelearn.microsoft.com

Prepare the data2 / 5

You create a Power Query query that groups sales by Region and calculates the sum of Amount for each region. Which M function performs this grouping and aggregation?

AlexFull explanation from Alex

Table.Group is the correct M function for grouping rows and applying aggregation in Power Query. It groups rows by specified key columns and produces aggregated values using functions like List.Sum, List.Count, List.Average, List.Min, and List.Max. In the Power Query Editor UI, this corresponds to the 'Group By' button on the Home tab. Syntax: Table.Group(table, key, aggregatedColumns). Note that Table.Aggregate does not exist as a standard M function, Table.Pivot reshapes data differently, and Table.Distinct removes duplicate rows without aggregation. (Ref: Microsoft Learn — Table.Group, Grouping or summarizing rows)

Sourcelearn.microsoft.com

Visualize and analyze the data3 / 5

You need to create a Power BI report that prints formatted invoices with precise page layout control, supports exporting to PDF with exact pagination, and can handle datasets with thousands of pages. Which type of report should you use?

AlexFull explanation from Alex

Paginated reports are the correct choice for scenarios requiring precise page layout control, pixel-perfect formatting, and support for large multi-page exports. They are optimized for printing and PDF export with exact pagination, making them ideal for formatted invoices, statements, and operational reports. Built on SQL Server Reporting Services (SSRS) technology, they are authored in Power BI Report Builder. Unlike standard Power BI reports (which are interactive and designed for screen exploration), paginated reports render every row of data across as many pages as needed. They support parameters, subreports, and complex table/matrix layouts. (Ref: Microsoft Learn — Paginated reports in the Power BI service)

Sourcelearn.microsoft.com

Model the data4 / 5

In a Power BI composite model, tables in DirectQuery mode always query the data source in real-time without any local caching.

AlexFull explanation from Alex

False. In a Power BI composite model, DirectQuery tables do not always query the source in real-time. Two features enable local caching: (1) Dual storage mode allows a table to be cached locally AND queried via DirectQuery, with Power BI choosing the optimal path per query. (2) User-defined aggregations let you create pre-aggregated cached tables that serve high-level queries without hitting the source. These features improve performance by reducing round-trips to the data source while maintaining near-real-time capability for detail-level queries. (Ref: Microsoft Learn — Composite model guidance in Power BI Desktop)

Sourcelearn.microsoft.com

Manage and secure Power BI5 / 5

In the Power BI service, you navigate to a workspace and see the sensitivity column next to reports. One report shows a shield icon with the label 'Highly Confidential'. Identify what this icon represents and where it was configured.

AlexFull explanation from Alex

Sensitivity labels in Power BI: sensitivity_label column shows classification. Information protection: Microsoft Purview integration. Labels: Confidential, Public, etc. Column: visible in workspace list. Inheritance: labels flow to exports. Mandatory: can be required by admin. Governance: data classification framework. Exam tip: Sensitivity label column in workspace. Microsoft Purview integration. Labels inherited on export.

Sourcelearn.microsoft.com

Create a free account

How to prepare for PL-300 with Pass-IT.

Currently 427 practice questions for PL-300, with new ones added regularly. Focus on what you still need to learn.

Get past difficult questions.

Understand why an answer is correct. Alex explains the concepts and answers your follow-up questions so you can apply what you learn to the next task.

Conversation preview · PL-300

Active relationships

You
Can both relationships between these two tables be active?
Alex · AI tutor
No. Only one relationship between the same two tables can be active at a time.
Read the Microsoft documentation ↗
You
How can a measure use the inactive relationship?
Alex · AI tutor
Use USERELATIONSHIP within CALCULATE for that calculation.
Read the Microsoft documentation ↗

Make your study time count.

Practice at your level.
For new practice sessions, Pass-IT adjusts the difficulty based on your previous answers.

Learn from mistakes.
Incorrect answers automatically become flashcards. When you review them, you rate how confidently you remember; Pass-IT schedules the next review.

See how focused practice works →

Animated feature preview

Turn your mistakes into knowledge you can rely on.

How Pass-IT works

Your review

Answered a question incorrectly?

Pass-IT saves it for your review.

PL-300 · Question excerpt

Active relationships

View the full question

A Power BI semantic model can have only one active relationship between any two tables at a time.

Understand the correct answer.

True

An inactive relationship can be used explicitly in a calculation with USERELATIONSHIP.

Read the Microsoft documentation ↗

How confidently do you remember?

During review, you assess how well you still know the answer.

Correct after hesitating

Pass-IT schedules your next review.

The date depends on your self-assessment and previous reviews.

Simplified demonstration. No learning progress is saved.

Practice for the moment that counts.

Take a full mock exam with a time limit and find out whether you can finish in time.

Your PL-300 mock exam

Questions: 50
Minutes: 100

Illustration of an exam session

Start
Answer questions
Finish

Length and time limit of the Pass-IT mock exam.

Go into your exam with more confidence.

Your Readiness Score helps you assess whether you are ready for the exam. Results by exam domain show you where you should keep practicing.

Your money back if you fail despite 80% Readiness.
If your Readiness Score is at least 80% when you take the exam and you still fail, we refund the Pass-IT purchase price for this certification.

For active, paid access. Submit proof of failing within 14 days.

Further guarantee conditions

You need at least 80% Readiness and active, paid access to the certification when you take the exam. Take the exam within your access period and submit official proof of failing within 14 days after the exam.

For purchases through Apple or Google, refunds are handled by the respective store. See the full terms for further details.

Read the guarantee terms →

The Readiness Score describes your practice progress, not a probability of passing.

Guarantee requirement

80%

At least 80% Readiness
when you take the exam

Money back if you fail

Question counts and mock exam settings from the current Pass-IT catalog.

Exam domains

What you practice for PL-300.

Exam topics, relevant practice and sources you can check.

Connecting and preparing data25–30% of the exam113 QuestionsPass-IT questions

This section covers bringing data into Power BI and shaping it into reliable tables.

Connect to data sources or shared semantic models, manage credentials, privacy settings and parameters, and choose Direct Lake, DirectQuery or Import.
Inspect data statistics and column properties, and resolve inconsistent, unexpected or null values, quality issues and import errors.
Set column types, create and transform columns, group and aggregate rows, pivot, unpivot or transpose data, and turn semi-structured data into tables.
Build fact and dimension tables with suitable keys for their relationships.
Choose reference or duplicate queries with their consequences in mind, merge or append queries, and configure how queries load data.

Official Microsoft objectives

Data models and DAX calculations25–30% of the exam117 QuestionsPass-IT questions

Understand how model relationships, calculations and design choices affect analysis and performance.

Configure table and column properties, role-playing dimensions, relationship cardinality and filter direction, a common date table, and suitable uses for calculated tables and columns.
Create aggregation, time-intelligence, statistical and semi-additive measures with DAX, using CALCULATE and quick measures where appropriate.
Create calculated tables, calculated columns and calculation groups.
Remove unnecessary rows and columns, reduce granularity, and use Performance Analyzer and DAX query view to find slow measures, relationships and visuals.

Official Microsoft objectives

Reports, exploration and usability25–30% of the exam122 QuestionsPass-IT questions

This section covers presenting data clearly, supporting exploration and making reports usable for different readers.

Choose and configure visuals and report pages, customize themes and conditional formatting, and apply slicers and filters.
Use Copilot to create narrative visuals and report pages, suggest page content and summarize the underlying semantic model.
Choose when paginated reports are appropriate and create visual calculations with DAX.
Configure bookmarks, tooltips, visual interactions, navigation, sorting and synchronized slicers; group and layer visuals in the Selection pane and set up drillthrough pages, filters and buttons.
Configure exports, mobile layouts, personalized visuals, accessibility and automatic page refresh.
Find patterns with Analyze, grouping, binning, clustering and AI visuals; use reference lines, error bars and forecasts, and detect outliers and anomalies.

Official Microsoft objectives

Managing and securing Power BI15–20% of the exam75 QuestionsPass-IT questions

Understand how to distribute Power BI content, keep it refreshed and control access.

Create and configure workspaces, apps and dashboards; publish, import and update workspace items, and choose how to distribute them.
Configure subscriptions and data alerts, and promote or certify Power BI content.
Identify when a gateway is needed and schedule semantic model refresh.
Assign workspace roles and item or semantic-model access, configure row-level security roles and group membership, and apply sensitivity labels.

Official Microsoft objectives

Question formats you can practice

Multiple Choice: Select one answer.
Multiple Response: Select multiple applicable answers.
True / False: Decide whether statements are true or false.
Drag & Drop: Match items to the appropriate targets.
Ordering: Put steps in the correct order.
Dropdown: Choose the appropriate entry from a dropdown list.

These are Pass-IT practice formats. Check the Microsoft certification page for the official exam information.

How we review questions

Source check: The answer, answer options and explanation are checked against official documentation. We call this canonical validation.

Adversarial review: An additional AI reviewer specifically looks for factual errors, ambiguous answers and weaknesses in the explanation.

Learning objectives: We count specific exam topics with clearly linked exercises. Subheadings are not counted separately.

The figures refer to available questions in each PL-300 exam domain. The additional review count includes matching review logs for the current question version, even if errors were found. It is not an error-free rate.

The date shows the latest matching evidence or log entry in each domain. An import or transfer of an existing review result can update this entry. This does not mean the entire question pool has been reviewed again.

Review methods and criteria in detail

The ranges describe the weighting of exam topics. See Official Microsoft objectives for the current exam objectives.

Frequently asked questions

Your preparation

How much study time should I plan for PL-300?

For planning, Pass-IT estimates roughly 25–70 hours. Relevant experience may put you toward the lower end; starting from scratch may put you toward the higher end. Your needs may fall outside this range. This is not a time requirement from Microsoft or a promise that you will be exam-ready within that time.

Using Pass-IT

What language are Pass-IT questions in?

Questions in the app are currently in English. Translations of the sample questions on this page apply only to this preview. Check with Microsoft for the languages available for the official exam.

How long does my PL-300 access last?

Access covers this certification for 12 months. You pay once, with no automatic renewal.

When does the money-back guarantee apply?

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days. Guarantee terms

About the PL-300 exam

Where can I take the PL-300 exam?

Pearson VUE online proctored or at authorized testing centers worldwide.

How long is the Microsoft Power BI Data Analyst exam?

The PL-300 exam has 50 questions and a 100-minute time limit.

How often do you renew PL-300?

Every year, through Microsoft's free renewal assessment on Microsoft Learn. It opens six months before expiry and must be completed before the date passes.

Who is PL-300 aimed at?

It is the associate-level exam for people who build Power BI reports professionally: data analysts, BI analysts and reporting specialists. The recurring difficulties are DAX calculations, Power Query M and row-level security, all of which reward practice over reading.

What happens if you fail PL-300?

You can retake after 24 hours. Each later attempt needs 14 days between sittings, up to five attempts within a 12-month period.

Your preparation for PL-300

$29.99one-time

12 months of access for PL-300 · No automatic renewal

Buy PL-300 access

Questions in the app are currently in English.

Try 20 questions for freeFree account required. No credit card.

Already have an account? Log in

Prefer a subscription? View subscriptions →

Money back if you fail with at least 80% Readiness, for eligible purchases under the guarantee terms.

Guarantee terms

The guarantee refunds the Pass-IT purchase price for this certification. You need eligible paid access and a Readiness Score of at least 80% from your practice results when you take the exam. This score can only reach 80% after at least 50 answered questions and is not a validated probability of passing. Take the exam during your access period and submit official proof of failing within 14 days.

Full guarantee terms →