Exam PL-300: Microsoft Power BI Data Analyst — Questions and Answers

Question 1: In a star schema, what is the purpose of a fact table?

To store measurable, quantitative data about business events (Correct answer)
To store lookup values for dropdowns
To define relationships between dimension tables
To store descriptive attributes about business entities

Correct answer: To store measurable, quantitative data about business events

Fact tables store numeric measurements (like sales amount, quantity) related to business events, referencing dimension tables via foreign keys.

Question 2: The term "_______________" refers to the process of quickly deploying and configuring cloud-based services as business requirements alter.

Agility (Correct answer)
Scalability
High availability
Elasticity

Correct answer: Agility

Agility in cloud computing refers to the ability to rapidly deploy, configure, and manage cloud-based services and applications in response to changing business needs. This allows organizations to quickly adapt, innovate, and bring new solutions to market without the delays associated with traditional infrastructure provisioning. It emphasizes speed and responsiveness to change.

Question 3: Which Power BI visual is most appropriate for displaying a single aggregated key metric prominently?

Card visual (Correct answer)
Matrix visual
Waterfall chart
Scatter chart

Correct answer: Card visual

The Card visual is specifically designed to display a single aggregated metric in large format on a report page.

Question 4: What is a Power BI workspace?

A premium feature only available in Power BI Premium
A local folder for storing .pbix files
A virtual machine for running Power BI Gateway
A collaborative environment in the Power BI service for sharing datasets, reports, and dashboards (Correct answer)

Correct answer: A collaborative environment in the Power BI service for sharing datasets, reports, and dashboards

Workspaces are containers in the Power BI service where teams collaborate on datasets, reports, and dashboards with shared access.

Question 5: You want to learn as soon as possible the percentage of empty cells or values in each column for the query that was opened in Power Query Editor. Which data preview option from the list below would you choose?

Column quality (Correct answer)
Column distribution
Show Whitespaces
Column profile

Correct answer: Column quality

Column quality in Power Query Editor provides a quick visual summary of each column's data, including the percentage of valid, error, and empty values. This feature is designed for rapid assessment of data completeness and quality directly within the data preview. By enabling it, you can instantly see the percentage of empty cells for every column.

Question 6: What Power BI license is required to share content with colleagues in your organization using the Power BI service?

Microsoft 365 Basic
Power BI Free
Power BI Desktop only
Power BI Pro or Premium Per User (PPU) (Correct answer)

Correct answer: Power BI Pro or Premium Per User (PPU)

Power BI Pro or Premium Per User (PPU) is required to share reports and dashboards with others and collaborate in workspaces.

Question 7: You are working with a sizable dataset that has more than a million rows. The table contains a Date datetime field. Without sacrificing data access, the data model needs to be shrunk. What ought you to do?

The Date column's data type should be changed to Text.
Round the Date column's hour to startOfHour.
Divide the Date column into two columns: one with just the time and the other with just the date. (Correct answer)
Cut the Date column out.

Correct answer: Divide the Date column into two columns: one with just the time and the other with just the date.

To shrink a data model with a large datetime column without sacrificing access to both date and time components, it's best to split the single datetime column into two separate columns: one for date and one for time. This reduces the storage footprint because date and time values, when stored separately, often require less memory than a single combined datetime column, especially if the time component has high granularity. This optimizes model size while retaining data granularity.

Question 8: Microsoft Power Platform is employed by a business. The business must read text from photographs that have been uploaded. You must choose the connector to use. Which connector should you utilize?

Microsoft Teams
Azure Blob storage
Azure Cognitive Services (Correct answer)
Microsoft Dataverse

Correct answer: Azure Cognitive Services

To read text from uploaded photographs, the 'Azure Cognitive Services' connector should be utilized. Azure Cognitive Services provides powerful AI capabilities, including Optical Character Recognition (OCR), which can extract text from images. This connector allows Power Platform components to leverage these advanced AI features for text extraction and analysis.

Question 9: What is the difference between a Power BI report and a dashboard?

Dashboards support drill-through; reports do not
There is no meaningful difference
Reports are multi-page interactive documents; dashboards are single-page pin boards with tiles from multiple reports (Correct answer)
Reports are read-only; dashboards are editable

Correct answer: Reports are multi-page interactive documents; dashboards are single-page pin boards with tiles from multiple reports

Reports are multi-page, interactive documents built from a single dataset; dashboards are single-page canvases with tiles pinned from various reports or datasets.

Question 10: In Power BI Desktop, which ribbon option allows you to configure how visuals interact with each other on a report page?

View ribbon > Page view
File > Options and settings
Format ribbon > Edit interactions (Correct answer)
Modeling ribbon > New parameter

Correct answer: Format ribbon > Edit interactions

The 'Edit interactions' option in the Format ribbon lets you control whether one visual filters, highlights, or has no effect on other visuals.

Question 11: You want to make a report with numerous visualizations using Power BI Desktop. You must produce a picture to illustrate the following: Users can search for values by which to filter the other visuals by using filters for other visuals on the same report page. Which type of visualization should you use?

Slicer (Correct answer)
Matrix
Funnel
Scatter chart

Correct answer: Slicer

A slicer is the ideal visualization for allowing users to interactively filter other visuals on the same report page by searching for specific values. Slicers provide an intuitive way to narrow down data, offering options like list, dropdown, or search boxes. This directly fulfills the requirement of enabling users to search for filter values, enhancing report interactivity.

Question 12: What is the main advantage of using DirectQuery mode instead of Import mode in Power BI?

Faster query performance due to in-memory storage
Data is always current because queries go directly to the source (Correct answer)
Reduces load on the source database
Supports all DAX functions without limitation

Correct answer: Data is always current because queries go directly to the source

DirectQuery sends queries to the source database in real time, ensuring data is always up-to-date without requiring scheduled refreshes.

Question 13: What language is used for transformations in Power Query?

Python
DAX
SQL
M (Power Query Formula Language) (Correct answer)

Correct answer: M (Power Query Formula Language)

Power Query uses the M language (Power Query Formula Language) to define all data transformation steps.

Question 14: A report consumer wants to save a specific view of a report with particular slicers set. Which Power BI feature supports this?

Bookmarks (Correct answer)
Pinned visuals
Report themes
Perspectives

Correct answer: Bookmarks

Bookmarks capture the current state of a report page including filter and slicer selections, allowing users to save and return to that specific view.

Question 15: Which Power BI service feature allows you to pin visuals from multiple reports into a single view?

Report
Dataflow
Dashboard (Correct answer)
App

Correct answer: Dashboard

Dashboards are single-page canvases where you pin visuals from multiple reports, datasets, or Q&A results for an at-a-glance overview.

Question 16: You must suggest a remedy that satisfies the following criteria: - Comprises business logic that allows for database product renaming - Increases table entries What should the recommendation contain?

an inline function
a view
a table-valued function
a stored procedure (Correct answer)

Correct answer: a stored procedure

A stored procedure is a pre-compiled collection of SQL statements and business logic stored in the database. It can accept parameters, perform complex operations like renaming products (updating multiple tables) and inserting new entries, offering better performance and security. Inline functions and views are primarily for returning data, not for complex transactional logic.

Question 17: You have a data model with a large number of intricate DAX expressions. The RELATED and RELATEDTABLE functions are frequently mentioned in the expressions. You must offer a suggestion for how to use the RELATED and RELATEDTABLE functions less frequently. What ought to you suggest?

Hide unused columns in the model.
Split the model into multiple models.
Transpose.
Merge tables by using Power Query. (Correct answer)

Correct answer: Merge tables by using Power Query.

The `RELATED` and `RELATEDTABLE` DAX functions are used to retrieve values from related tables. If these functions are used extensively and causing performance issues, a common optimization is to denormalize the data by merging tables in Power Query. This pre-joins the necessary data, reducing the need for DAX to perform lookups across relationships at query time, thereby simplifying expressions and improving model performance.

Question 18: What does the RANKX function return when two items have the same value?

An error message
The same rank for both, then skips the next rank (Correct answer)
The rank of the first item encountered
Consecutive ranks with no gaps

Correct answer: The same rank for both, then skips the next rank

By default, RANKX assigns the same rank to tied items and then skips subsequent ranks (dense ranking must be specified explicitly).

Question 19: What is the purpose of the ALLEXCEPT function in DAX?

Returns all rows except blank values
Removes all filters from the model except calculated columns
Applies filters to all tables except the one specified
Removes all filters from a table except those applied to specified columns (Correct answer)

Correct answer: Removes all filters from a table except those applied to specified columns

ALLEXCEPT removes all context filters from a table except for filters on the columns you explicitly list, useful for ratio calculations that need to preserve certain filter context.

Question 20: A Microsoft Excel data source's file name and location are stored in a parameter you construct called DataSourceExcel. Instead of using numerous copies of the location that are hard-coded into each query definition, you must edit the query to reference the parameter. Solution: Replace all references to the Excel file in the Power Query M code with references to DataSourceExcel. Is the objective being met?

No (Correct answer)
Yes

Correct answer: No

Simply replacing hard-coded references with the parameter name in the M code is not sufficient for Power Query to correctly use the parameter. For the parameter to be properly integrated, the query's source step needs to be explicitly modified to *use* the `DataSourceExcel` parameter as its input for the file path. The solution implies a simple text replacement, which doesn't correctly configure the data source to dynamically reference the parameter.

Question 21: In Power BI, what does the 'Spotlight' feature do when activated from a visual's context menu?

It adds a highlight annotation box around the visual for use in presentation mode
It focuses attention on one visual by dimming all other visuals on the report page (Correct answer)
It pins the visual to a dashboard directly from within the report
It publishes a single visual to the Power BI service independently of the report

Correct answer: It focuses attention on one visual by dimming all other visuals on the report page

The Spotlight feature dims all other visuals on the report page, drawing the viewer's attention to the selected visual — useful when presenting specific insights.

Question 22: You have shared control over a Power BI workspace. The workspace includes the DS1 dataset. You intend to schedule DS1's refresh. What is the daily maximum for data refreshes?

8 (Correct answer)
24
1
4

Correct answer: 8

For datasets in a shared capacity Power BI workspace, the maximum number of daily scheduled refreshes is eight. This limit applies to datasets that are not hosted in a Premium capacity. Premium capacities offer increased refresh frequency, allowing up to 48 refreshes per day.

Question 23: What is the role of a 'Role-Playing Dimension' in a Power BI data model?

A single dimension table referenced multiple times via inactive relationships for different date contexts (Correct answer)
A dimension shared across multiple datasets
A dimension used only for row-level security
A table with multiple primary keys

Correct answer: A single dimension table referenced multiple times via inactive relationships for different date contexts

Role-playing dimensions allow a single dimension (like Date) to serve multiple roles (e.g., Order Date, Ship Date) using inactive relationships activated by USERELATIONSHIP.

Question 24: What does 'incremental refresh' do for a Power BI dataset?

Refreshes in small increments to reduce Gateway load
Adds new columns incrementally over multiple refreshes
Refreshes the report visuals without changing the data
Refreshes only a portion of data based on date ranges, rather than reloading the entire dataset (Correct answer)

Correct answer: Refreshes only a portion of data based on date ranges, rather than reloading the entire dataset

Incremental refresh loads only new and updated data for defined date ranges, dramatically reducing refresh times and resource usage for large datasets.

Question 25: What function does Power BI's Row Level Security (RLS) serve?

Restricting data access for the given users ( By assigning users to roles) (Correct answer)
Restrictions to specific measures within Power BI reports to some specific users
Adding the ability to link Power BI Log-in to organizational Active Directory or Window Login through Single Sign On (SSO)
All the above

Correct answer: Restricting data access for the given users ( By assigning users to roles)

Row-Level Security (RLS) in Power BI is designed to restrict data access at the row level based on the user executing the report. It works by defining roles and rules within Power BI Desktop, which are then applied to users or groups in the Power BI service, ensuring they only see the data they are authorized for. This prevents unauthorized users from viewing sensitive data rows.

Question 26: Which Power BI visual type is best suited for displaying trends over a continuous time period?

Funnel chart
Pie chart
Line chart (Correct answer)
Treemap

Correct answer: Line chart

Line charts connect data points sequentially over time, making trends immediately visible to the viewer.

Question 27: You must establish a sales quote approval procedure. Which component of the Microsoft Power Platform should you use?

AI Builder
Power Automate (Correct answer)
Power BI
Power Virtual Agents

Correct answer: Power Automate

To establish a sales quote approval procedure, 'Power Automate' is the ideal component of the Microsoft Power Platform. Power Automate specializes in creating automated workflows and business processes, including multi-step approvals. It can integrate with various services to trigger actions, send notifications, and manage the approval flow for sales quotes.

Question 28: You have shared control over a Power BI workspace. The workspace includes a report that makes use of the DS1 dataset. A DS1 incremental refresh must be implemented. What ought to you start with?

Upgrade to the Premium SKU for the Power BI workspace.
the dataset should be published to the Power BI service.
Define filter parameters in Power BI Desktop. (Correct answer)
Define the incremental refresh policy in Power BI Desktop.

Correct answer: Define filter parameters in Power BI Desktop.

The first step to implement incremental refresh in Power BI Desktop is to define `RangeStart` and `RangeEnd` parameters. These parameters, typically of type `DateTime`, are used to filter the data that will be incrementally refreshed. Power BI then uses these parameters to dynamically query only the new or updated data from the source, which is crucial for efficient incremental refresh.

Question 29: Which DAX function calculates year-to-date totals?

DATEYTD
TOTALYTD (Correct answer)
YTDTOTAL
SUMYTD

Correct answer: TOTALYTD

TOTALYTD evaluates an expression from the beginning of the year to the last date in the current filter context.

Question 30: What does the Power BI service 'Lineage view' show?

A list of users who accessed a report
A visual map of data sources, dataflows, datasets, reports, and dashboards and their dependencies (Correct answer)
The history of changes to a report
The refresh schedule history

Correct answer: A visual map of data sources, dataflows, datasets, reports, and dashboards and their dependencies

Lineage view displays the end-to-end data flow from source to report, showing how content items depend on each other in a workspace.

Question 31: What is the purpose of 'Sensitivity Labels' in Power BI?

To mark reports as confidential from external sharing only
To tag reports by topic for easier search
To set report visual themes
To classify and protect data by applying Microsoft Information Protection labels to datasets and reports (Correct answer)

Correct answer: To classify and protect data by applying Microsoft Information Protection labels to datasets and reports

Sensitivity labels from Microsoft Information Protection can be applied to Power BI content to classify data and enforce protection policies like encryption.

Question 32: What does the 'Endorsement' feature in Power BI do?

Encrypts a dataset with a customer-managed key
Locks a dataset to prevent changes
Approves a report for external sharing
Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness (Correct answer)

Correct answer: Marks datasets, dataflows, or reports as Promoted or Certified to signal quality and trustworthiness

Endorsement (Promoted or Certified) labels help consumers identify trusted, high-quality content in the Power BI service.

Question 33: A Microsoft Dataverse table is linked to a canvas app that you construct. You must share the app. What are the two things you should do? Each right response offers a piece of the answer. Select all applicable answers.

Publish the app. (Correct answer)
Incorporate a security role. (Correct answer)
Email the users to inform them.
Permit users to edit the application.

Correct answer: Publish the app.

When sharing a canvas app linked to Microsoft Dataverse, two crucial steps are required. First, you must 'Publish the app' to make the latest version available to users. Second, you need to 'Incorporate a security role' to control what data users can access within Dataverse, ensuring data security and proper permissions.

Question 34: How can Power BI reports be embedded in external websites for non-Power BI users?

By publishing to the web using 'Publish to web' to generate a public embed code (Correct answer)
By converting to a static PDF
By sharing a direct link to the Power BI service
By exporting as an image and hosting it

Correct answer: By publishing to the web using 'Publish to web' to generate a public embed code

The 'Publish to web' feature generates a public embed code (iframe/URL) that allows anyone to view the report without a Power BI account.

Question 35: What is row-level security (RLS) in Power BI?

A feature that restricts data access for specific users based on DAX filter rules (Correct answer)
A sorting mechanism for table rows
Encryption of individual rows in a dataset
A backup mechanism for dataset rows

Correct answer: A feature that restricts data access for specific users based on DAX filter rules

RLS uses DAX filter expressions applied to roles to ensure users only see data they are authorized to view when accessing a report.

Question 36: Which Power BI chart type displays hierarchical data as nested rectangles where each rectangle's size represents its proportional value?

Treemap (Correct answer)
Donut chart
Gauge chart
Funnel chart

Correct answer: Treemap

Treemaps display hierarchical data as nested rectangles where each rectangle's size is proportional to its underlying value.

Question 37: Create a canvas application. Users must be able to choose from one or more values for a field. Which three controls are the best to use? Each accurate response offers an entire resolution. Select all applicable answers.

Combo box (Correct answer)
Rating
Dropdown (Correct answer)
List box (Correct answer)
Radio

Correct answer: Combo box

To allow users to select one or more values for a field in a canvas app, several controls are effective. A 'List box' explicitly supports multi-selection, letting users pick multiple items from a visible list. A 'Combo box' also offers multi-select capabilities and a search function, while a 'Dropdown' allows selection from a list and can be configured for multi-select in some contexts, or is a common choice for single selection from a list of values.

Question 38: What is a 'shared dataset' in the Power BI service?

A dataset published to the service that multiple reports across different workspaces can connect to and reuse (Correct answer)
A read-only snapshot exported from another system
A dataset hosted on a shared file server
A dataset shared only within My Workspace

Correct answer: A dataset published to the service that multiple reports across different workspaces can connect to and reuse

Shared datasets allow multiple reports to connect to a single published dataset, ensuring consistent metrics and reducing duplication across teams.

Question 39: You are in charge of a Power BI workspace with a dataset containing sales information for your business. You design a report that shows sales information broken down by department. Row-level security must be used to guarantee that, after the report is released, only the sales data for each department's personnel will be seen. What should you do first?

Define filter parameters in Power BI Desktop.
Create a role in Power BI Desktop. (Correct answer)
Upgrade to the Premium SKU for the Power BI workspace.
The report should be deployed to the Power BI service.

Correct answer: Create a role in Power BI Desktop.

The initial step for implementing Row-Level Security (RLS) in Power BI is to define roles and their corresponding DAX filter expressions within Power BI Desktop. These roles specify which rows of data users assigned to that role can see. After defining roles, the report can be published, and users or security groups can then be assigned to these roles in the Power BI service to enforce the security.

Question 40: How often can a Power BI dataset be scheduled to refresh with a Pro license?

Up to 8 times per day (Correct answer)
Unlimited refreshes
Up to 48 times per day
Once per day

Correct answer: Up to 8 times per day

With a Power BI Pro license, you can schedule up to 8 daily refreshes per dataset; Premium capacities allow up to 48 refreshes per day.

Exam PL-300: Microsoft Power BI Data Analyst

This exam certifies data professionals who design and build scalable data models, clean and transform data, and enable advanced analytic capabilities using Microsoft Power BI.

Questions

120 min

Time Limit

70%

To Pass

Checking for saved progress...

Exam Rules

You can skip questions and return to them later
Flag questions for review before submitting
No feedback shown until you submit the entire exam
Unanswered questions count as wrong — answer everything
10 pretest questions are mixed in and don't affect your score
Timer auto-submits when time runs out
Your progress is auto-saved every 30 seconds

These practice questions were written with AI tools. They are not real exam questions. Exam facts are checked against the official sources listed below. Not reviewed by a subject-matter expert. Editorial policy

Sources & references

Exam facts on this page (fees, format, dates, passing scores) are checked against these official sources; the date is our last check. Editorial policy

learn.microsoft.com — Passing score, renewal, fees, time limit, score validity, retake fee, exam information · verified Oct 2026
pearsonvue.com — Test delivery · verified Oct 2026