PL-300 Practice Questions

Question 1

You want to create a custom visual that is not available in the default Power BI visuals pane. What should you do?

Accepted Answer

Download the visual from AppSource and import it.. Custom visuals can be imported from AppSource or a file. The option to get from AppSource is standard.

Answer

Write the visual in Python and add it to the report.

Answer

Use the R script visual to create the visual.

Answer

Create a custom visual using Power BI Desktop's built-in editor.

Question 2

You are a Power BI administrator. You need to prevent users from exporting underlying data from reports. Which tenant setting should you disable?

Accepted Answer

'Export data'. 'Export data' controls the ability to export underlying data. Option B is wrong because 'Export reports as PowerPoint' is for exporting the report itself. Option C is wrong because 'Export reports as PDF' is for static exports. Option D is wrong because 'Export reports as MHTML' is also for report export.

Answer

'Export reports as PowerPoint presentations'

Answer

'Export reports as PDF files'

Answer

'Export reports as MHTML files'

Question 3

You are a data analyst for a utility company. You import a table named MeterReadings from an OData feed. The table contains a column named ReadingTimestamp that includes date and time. You need to create two new columns: one that contains only the date and one that contains only the hour of the day as a number (0–23). You want to use built-in Power Query transformations from the Add Column tab without writing custom formulas. Which two transformations should you use? (Choose two.)

Accepted Answer

Select ReadingTimestamp, then on the Add Column tab choose Time and select Hour.. To create a date-only column and an hour column from a timestamp, you use the Date Only transformation and the Hour transformation, both available on the Add Column tab. These are built-in, code-free operations that add new columns while keeping the original timestamp. Other date or time transformations extract different components and do not meet the stated requirements.

Answer

Select ReadingTimestamp, then on the Add Column tab choose Date and select Year.

Answer

Select ReadingTimestamp, then on the Add Column tab choose Time and select Duration.

Answer

Select ReadingTimestamp, then on the Add Column tab choose Date and select Month.

Question 4

You want to allow users to highlight different product categories in a line chart by selecting from a list. Which feature should you add?

Accepted Answer

Slicer. A slicer filters or highlights data based on selection, making it ideal for category selection. Bookmarks save a state, drillthrough navigates to another page, and tooltips show details on hover.

Answer

Tooltip

Answer

Bookmarks

Answer

Drillthrough

Question 5

You need to create a visual that shows the relationship between advertising spend and website traffic. Which type of visual is most appropriate?

Accepted Answer

Scatter chart. Scatter charts are ideal for showing relationships between two numeric variables. A line chart shows trends over time, a bar chart compares categories, and a pie chart shows proportions.

Answer

Stacked bar chart

Answer

Pie chart

Answer

Line chart

Question 6

Refer to the exhibit. You have a Power BI dataset with the JSON policy shown. You add a user to the USOnly role. What happens when that user views a report based on this dataset?

Accepted Answer

The user sees only rows where Region is 'US' in the Sales table.. Row-level security (RLS) restricts data: only rows where Region is 'US' are visible. Option A is wrong because RLS does not hide the entire table. Option C is wrong because RLS does not affect columns. Option D is wrong because RLS does not affect other tables unless defined.

Answer

The user sees all rows in the Sales table.

Answer

The user sees all rows but the SalesAmount column is hidden.

Answer

The user sees all rows in all tables of the dataset.

Question 7

Your Power BI report includes a map visual showing store locations. However, some locations are not appearing correctly because of ambiguous place names. What should you do to ensure accurate geocoding?

Accepted Answer

Use latitude and longitude fields instead of location names. Using latitude and longitude fields bypasses Bing's geocoding, ensuring accuracy. Changing the map style does not fix geocoding, using a filled map is for regions, and a bubble chart is not geographic.

Answer

Aggregate the data by country

Answer

Switch to a bubble chart

Answer

Change the map visual to a filled map

Question 8

A data analyst needs to combine two queries in Power Query: 'Sales2023' and 'Sales2024', both with identical column structures. Which operation should the analyst use to append the rows from 'Sales2024' to 'Sales2023'?

Accepted Answer

Append Queries. The Append Queries operation in Power Query is designed to combine rows from two or more tables with identical column structures, stacking the rows of 'Sales2024' beneath those of 'Sales2023'. This is the correct method because it preserves all columns and adds data vertically, which matches the requirement to append rows.

Answer

Merge Queries

Answer

Group By

Answer

Pivot Column

Question 9

Which TWO are valid reasons to use a dataflow in Power BI when preparing data?

Accepted Answer

To handle large data volumes that exceed dataset limits. Option A is correct because dataflows store transformed data in Common Data Model (CDM) entities in Azure Data Lake Storage Gen2, so they can process and persist large data volumes that would otherwise exceed a single dataset's size or memory limits. Option B is correct because a dataflow's CDM entities can be consumed by multiple Power BI datasets, letting you define the transformation logic once and reuse the same cleansed data across many datasets instead of duplicating ETL work. Option C is not a valid reason, since dataflows that connect to on-premises sources still require an on-premises data gateway; dataflows do not eliminate that need. Option D is not correct because dataflows are refreshed on a scheduled (batch) basis and are not a mechanism for real-time streaming, which is handled by streaming datasets or push datasets. Option E is not correct because data lineage is a metadata/governance feature surfaced automatically in the workspace, not something a dataflow is used to enforce.

Answer

To avoid using an on-premises data gateway

Answer

To achieve real-time data refresh

Answer

To automatically enforce data lineage

Question 10

You have a report with a line chart showing monthly sales. Users need to see the exact sales value when they hover over a data point. What should you configure?

Accepted Answer

Configure the visual's tooltip to display the value.. Tooltips in Power BI are designed to show detailed information about a data point when the user hovers over it. By default, the visual's tooltip already includes the value, but if it has been customized or removed, you need to ensure the tooltip is configured to display the sales value. This provides an interactive way to see exact numbers without cluttering the chart with permanent labels.

Answer

Enable data labels on the chart.

Answer

Add a report page tooltip.

Answer

Set the category label to show the value.

Question 11

You need to create a calculated column in Power BI that shows the full name by combining 'FirstName' and 'LastName' columns with a space. Which DAX expression should you use?

Accepted Answer

FullName = [FirstName] & " " & [LastName]. The DAX concatenation operator is the ampersand (&). Option B is wrong because CONCATENATE function only takes two arguments. Option C is wrong because CONCATENATEX is for tables. Option D is wrong because the plus sign is for addition.

Answer

FullName = CONCATENATE([FirstName], " ", [LastName])

Answer

FullName = CONCATENATEX(Table, [FirstName] & " " & [LastName])

Answer

FullName = [FirstName] + " " + [LastName]

Question 12

You have a Power BI dataset that uses data from Microsoft Excel files stored in SharePoint Online. Users report that the data is not refreshing as scheduled. You verify that the gateway is installed and running. What is the most likely cause of the refresh failure?

Accepted Answer

The data source credentials are not provided in the gateway.. Even when the gateway is installed and running, it must have valid data source credentials configured for the SharePoint Online Excel files. Without these credentials, the gateway cannot authenticate to SharePoint Online to retrieve the data, causing the scheduled refresh to fail. The gateway uses the stored credentials to connect to the data source during each refresh cycle.

Answer

The gateway is not running.

Answer

The gateway does not support SharePoint Online data sources.

Answer

The gateway is not configured to use the on-premises data source type.

Question 13

A Power BI data model includes a table 'Orders' with columns OrderID, CustomerID, OrderDate, SalesAmount. The model also has a 'Date' table and a 'Customer' table. The relationships are: Orders[CustomerID] -> Customer[CustomerID] (many-to-one, single direction) and Orders[OrderDate] -> Date[Date] (many-to-one, single direction). A user creates a measure that sums SalesAmount and then filters by a slicer on Customer[City]. The slicer works correctly. However, when the user adds another slicer on Date[Year], the measure does not respect both slicers simultaneously. What is the most likely cause?

Accepted Answer

The measure might be using ALL or ALLEXCEPT that removes the filter context from the Date table.. The measure likely uses ALL or ALLEXCEPT, which removes the filter context from the Date table. Even though the relationships are correctly configured and filters from the Date slicer propagate to Orders via the single-direction relationship, if the measure explicitly ignores those filters using a function like ALL(Date[Year]) or ALLEXCEPT(Orders, ...), the Date slicer will have no effect on the measure. This is a common DAX mistake where filter removal functions override slicer selections.

Answer

The Customer and Date tables are not related to each other.

Answer

The relationship between Orders and Date is inactive.

Answer

The relationships are set to single direction, so filters from Date do not propagate to Orders.

Question 14

You have the above M query. You need to load only the top 10 customers by sales. What should you add to the query?

Accepted Answer

Add Table.FirstN(#"Sorted Rows", 10) after sorting.. The query already sorts by Total Sales descending. To get top 10, you need to add a step to keep the first 10 rows, using Table.FirstN.

Answer

Add a step to use Table.SelectRows with a condition on rank.

Answer

Add a filter to keep only rows where [Total Sales] is in the top 10 values.

Answer

Add a step to use Table.StopAfter(#"Sorted Rows", 10).

Question 15

You are troubleshooting a Power Query transformation that groups sales data by ProductID. The query runs slowly and you suspect the filter is being applied after loading all rows. What change would improve performance by pushing the filter to the source?

Accepted Answer

Replace the first three lines with a native SQL query that includes the WHERE clause. Pushing filter logic to the source database via a native SQL query with a WHERE clause reduces the amount of data loaded into Power Query. This leverages query folding, which allows the source (e.g., SQL Server) to perform the filtering before data is transferred, significantly improving performance for large datasets.

Answer

Disable the 'Enable load' option for the SalesTable

Answer

Use CALCULATE in DAX to filter

Answer

Add a 'Table.Buffer' step after the filter

Microsoft Power BI Data Analyst PL-300 practice test

Three ways to study

Study PL-300 by domain

Study PL-300 by topic

Deploy and maintain assets practice questions

Prepare the data practice questions

Visualize and analyze the data practice questions

Manage and secure Power BI practice questions

Model the data practice questions

PL-300 fundamentals practice questions

PL-300 scenario practice questions

PL-300 troubleshooting practice questions

Top PL-300 questions

Microsoft Power BI Data Analyst PL-300 practice questions