[Feb 07, 2026] Verified PL-300 dumps and 466 unique questions [Q146-Q164]

Rate this post

[Feb 07, 2026] Verified PL-300 dumps and 466 unique questions

PL-300 Dumps for Pass Guaranteed – Pass PL-300 Exam 2026

Microsoft PL-300 certification exam is intended for individuals who have a strong background in data analysis and are familiar with the concepts of data modeling, data visualization, and data manipulation. PL-300 exam evaluates the knowledge of candidates in designing and building Power BI solutions, creating reports and dashboards, and managing the Power BI service.

In order to prepare for the Microsoft PL-300 exam, candidates should have a good understanding of the Power BI platform and should be comfortable working with data to create reports and visualizations. There are many resources available to help candidates prepare for the exam, including online courses, study guides, and practice exams. By taking advantage of these resources, candidates can increase their chances of passing the exam and earning their Microsoft PL-300 certification.

NO.146 You have a dataset that contains revenue data from the past year.
You need to use anomaly detection in Power Bl to show anomalies in the dataset.
What should you configure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.147 Your organization has a team of power users who recently created 20 Power BI dashboards.
The power users share the dashboards with other users in the organization.
When the users attempt to access the dashboards, they receive the error message shown in the exhibit. (Click the Exhibit.)

You need to ensure that all the users can access the dashboards.
What should you do first?

From the Microsoft Office 365 Admin center, and the Power BI (free) subscription, and then assign a license to each user.

From the Power BI Admin portal, modify the Privacy Settings.

From the properties of each dashboard, modify the Share dashboard settings.

Instruct each user to install Microsoft Office 2016.

NO.148 You have five sales regions. Each region is assigned a single salesperson.
You have an imported dataset that has a dynamic row-level security (RLS) role named Sales. The Sales role filters sales transaction data by salesperson.
Salespeople must see only the data from their region.
You publish the dataset to powerbi.com, set RLS role membership, and distribute the dataset and related reports to the salespeople.
A salesperson reports that she believes she should see more data.
You need to verify what data the salesperson currently sees.
What should you do?

Use the Test as role option to view data as the salesperson’s user account.

Use the Test as role option to view data as the Sales role.

Instruct the salesperson to open the report in Microsoft Power Bl Desktop.

Filter the data in the reports to match the intended logic in the filter on the sales transaction table.

NO.149 You are reviewing a query that produces 10,000 rows in the Power Query Editor.
You need to identify whether a column contains only unique values.
Which two Data Preview options can you use? Each correct answer presents a complete solution.
NOTE: Each correct selection is worth one point.

Column profile

Column distribution

Show whitespace

Column quality

Monospace

NO.150 You open powerbi.com as shown in the following exhibit.

Use the drop-down menus to select the answer choice that completes each statement based on the information presented in the graphic.
NOTE: Each correct selection is worth one point.

NO.151 You import two Microsoft Excel tables named Customer and Address into Power Query.
Customer contains the following columns:
* Customer ID
* Customer Name
* Phone
* Email Address
* Address ID
Address contains the following columns:
* Address ID
* Address Line 1
* Address Line 2
* City
* State/Region
* Country
* Postal Code
The Customer ID and Address ID columns represent unique rows.
You need to create a query that has one row per customer. Each row must contain City, State/Region, and Country for each customer.
What should you do?

Merge the Customer and Address tables.

Transpose the Customer and Address tables.

Group the Customer and Address tables by the Address ID column.

Append the Customer and Address tables.

NO.152 You need to recommend a strategy to consistently define the business unit, department, and product category data and make the data usable across reports.
What should you recommend?

Create a shared dataset for each standardized entity.

Create dataflows for the standardized data and make the dataflows available for use in all imported datasets.

For every report, create and use a single shared dataset that contains the standardized data.

For the three entities, create exports of the data from the Power Bl model to Excel and store the data in Microsoft OneDrive for others to use as a source.

NO.153 You have the Power BI data model shown in the following exhibit.

Select the appropriate yes or no.

NO.154 For the sales department at your company, you publish a Power Bl report that imports data from a Microsoft Excel.
We located in a Microsoft SharePoint folder. The data model contains several measures.
You need to create a Power Bl report from the existing data. The solution must minimize development effort.
Which type of data source should you use?

a SharePoint folder

Power Bl dataflows

an Excel workbook

Power Bl dataset

NO.155 You have a query named Customer that imports CSV files from a data lake. The query contains 500 rows as shown in the exhibit. (Click the Exhibit

Each file contains deltas of any new or modified rows from each load to the data lake. Multiple files can have the same customer ID.
You need to keep only the last modified row for each customer ID.
Which three actions should you perform in sequence? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.

NO.156 You have a custom connector that returns ID, From, To, Subject, Body, and Has Attachments for every email sent during the past year. More than 10 million records are returned.
You build a report analyzing the internal networks of employees based on whom they send emails to.
You need to prevent report recipients from reading the analyzed emails. The solution must minimize the model size.
What should you do?

Implement row-level security (RLS) so that the report recipients can only see results based on the emails they sent.

Remove the Subject and Body columns during the import.

From Model view, set the Subject and Body columns to Hidden.

NO.157 You are enhancing a Power BI model that has DAX calculations.
You need to create a measure that returns the year-to-date total sales from the same date of the previous calendar year.
Which DAX functions should you use? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.158 Drag and Drop Question
You have a Power BI model that contains a table named Sales. Sales has the following three measures:
– A measure named Total Sales Last Year that displays the sales from
the previous calendar year. The current value is 32.89 million.
– A measure named Total Sales This Year that displays the sales from
the current calendar year. The current value is 11.69 million.
– A measure named Total Sales Difference that uses a DAX formula of
Sales[Last Year] – Sales[This Year].
You need to create the following visualization.

How should you configure the visualization? To answer, drag the appropriate measures to the correct fields. Each value may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

NO.159 Each employee has one manager as shown in the ParentEmployeelD column,
All reporting paths lead to the CEO at the top of the organizational hierarchy.
You need to create a calculated column that returns the count of levels from each employee to the CEO.
Which DAX expression should you use?

Option A

Option B

option C

Option D

NO.160 You build a report to help the sales team understand its performance and the drivers of sales. The team needs to have a single visualization to identify which factors affect success .
Which type of visualization should you use?

Key influences

Funnel chart

Q&A

Line and clustered column chart

NO.161 You are building a financial report by using Power BI.
You have a table named financials that contains a column named Date and a column named Sales.
You need to create a measure that calculates the relative change in sales as compared to the previous quarter.
How should you complete the measure? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

NO.162 You have the Power Bl data model shown in the following exhibit.
You create two row-level security (RlS) roles named Manager and CFO.
You plan to publish the dataset to the Power Bl service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
* Each manager must see only the data in the Sales and Human Resources tables for their own country.
* The CFO must be prevented from seeing the data in the Human Resources table.
* The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

The Country table contains the following data.

You plan to publish the dataset to the Power Bl service.
You need to create DAX expressions for the RLS filters. The solution must meet the following requirements:
* Each manager must see only the data in the Sales and Human Resources tables for their own country.
* The CFO must be prevented from seeing the data in the Human Resources table.
* The CFO must see the sales data of all countries.
How should you complete the DAX expressions to meet the requirements? To answer, drag the appropriate expressions to the correct targets. Each expression may be used once, more than once, or not at all. You may need to drag the split bar between panes or scroll to view content.
NOTE: Each correct selection is worth one point.

NO.163 You plan to create a Power BI semantic model named Model1 that will contain data from an Azure SQL database named DB1.
Model1 must show updated data within two minutes of the data being updated in DB1.
You need to select a connectivity mode for the connection to DB1.
What should you choose?

DirectQuery

live connection

import

NO.164 You have a Power Bl report that contains a table visual with a measure named Revenue. The Revenue measure returns values within a range of 0 to S. You need to formal the visual so that the Revenue column displays a specific background color based on the value range shown in the following table.

Which three actions should you perform in sequence in Power B) Desktop? To answer, move the appropriate actions from the list of actions to the answer area and arrange them in the correct order.