Microsoft Power BI Data Analyst

Question 1

You are finalizing a Power BI report that will be consumed by users who rely on keyboard navigation and screen readers. On the main page, several decorative shapes and a company logo image are being read aloud by the screen reader, and users must tab through them before reaching the key visuals. You need to ensure that keyboard users can move directly to the meaningful visuals in a logical sequence without the decorative elements interrupting them. What should you do?

Accepted Answer

Open the Selection pane, use the Tab order tab to reorder the visuals, and remove the decorative shapes and logo from the tab order.

Answer

Add descriptive alt text to the decorative shapes and logo so the screen reader announces them meaningfully.

Answer

Turn on the report's high-contrast theme so the decorative elements are visually de-emphasized.

Answer

Enable Focus mode on each key visual so keyboard users open them one at a time.

Question 2

You import a Product dimension table into Power Query. The source has no reliable unique identifier because the natural business key (ProductCode) contains occasional duplicates caused by legacy data entry, and you must relate this dimension to a large Sales fact table. You want a guaranteed unique key to use as the one-side of the relationship without altering the existing ProductCode values. What is the most appropriate step to take in Power Query?

Accepted Answer

Add an Index column starting from 1 to serve as a surrogate key for the dimension

Answer

Duplicate the ProductCode column and change its data type to Text

Answer

Use Remove Duplicates on ProductCode so the column becomes unique

Answer

Group by ProductCode and count rows to detect the duplicates

Question 3

You have a clustered column chart showing monthly Total Revenue by Product Category. The regional director notices that revenue dropped sharply from Q2 to Q3 and asks which factors contributed most to the decline across all your dimensions (Region, Channel, and Salesperson). You want Power BI to automatically rank and visualize the segments that drove the decrease without manually building additional visuals. Which built-in capability should you use?

Accepted Answer

Right-click the Q3 data point and choose Analyze > Explain the decrease

Answer

Add a Key Influencers visual with Total Revenue as the field to analyze

Answer

Enable forecasting in the Analytics pane to project the revenue trend

Answer

Apply a Top N filter on the visual to show only the highest revenue categories

Question 4

A sales manager is reviewing a clustered column chart that shows total revenue by month. Revenue jumped sharply from April to May, and the manager wants Power BI to automatically break down which categories and regions contributed most to that specific month-over-month increase, without manually building additional visuals. Which built-in feature should you use?

Accepted Answer

Right-click the May data point and choose Analyze > Explain the increase

Answer

Add a forecast from the Analytics pane to project future revenue

Answer

Apply the Key influencers visual with revenue as the analyzed field

Answer

Enable anomaly detection on the column chart to flag unexpected values

Question 5

A retail analyst has a line chart showing daily online sales over the past two years. Management wants Power BI to automatically highlight unexpected spikes and dips in the daily sales trend, along with possible explanations for each unusual value. Which built-in analytics feature should the analyst enable to meet this requirement with the least manual effort?

Accepted Answer

Turn on Anomaly detection for the line chart from the Analytics pane

Answer

Add a Forecast line from the Analytics pane to project future sales values

Answer

Apply grouping and binning to the date axis to cluster similar sales values

Answer

Use conditional formatting with a color scale on the sales measure

Question 6

You are combining two annual sales extracts in Power Query. The 2023 file uses a column named 'CustomerID', while the 2024 file names the same column 'Customer_ID'. All other columns share identical names. After using Append Queries to stack the two tables, you notice the combined table contains two separate columns—'CustomerID' and 'Customer_ID'—each populated for only one year and null for the other. What is the most appropriate way to correct this before loading?

Accepted Answer

Rename the column in one of the source queries so both queries use the same column name, then re-run the append.

Answer

Add a custom column that coalesces the two columns, then remove the originals after the append.

Answer

Change the append operation to a Merge with a full outer join on both ID columns.

Answer

Enable 'Use first row as headers' on the appended query to unify the column names.

Question 7

You manage a Power BI workspace that contains several reports and a shared semantic model for the finance team. A group of business analysts needs to open and interact with the existing reports (using slicers and filters) but must not be able to edit, delete, publish, or reshare any content. You want to grant this access with the least privilege while assigning a single workspace role. Which workspace role should you assign to the analysts?

Accepted Answer

Viewer

Answer

Contributor

Answer

Member

Answer

Admin

Question 8

You maintain a Power BI model in DirectQuery mode over an Azure SQL Database. The model has a single many-to-one relationship between a large Sales fact table and a Product dimension. You have verified that every ProductKey in Sales exists in the Product table (the source enforces a foreign-key constraint). Query performance on visuals that combine Sales and Product is slower than expected. Which relationship setting should you enable to improve DirectQuery performance while keeping results correct?

Accepted Answer

Enable 'Assume referential integrity' on the relationship

Answer

Change the cross-filter direction to 'Both'

Answer

Change the cardinality to many-to-many

Answer

Enable 'Apply security filter in both directions'

Question 9

You have a star schema with a Sales fact table related to Product and Customer dimensions. A new requirement asks that slicing by Product also filters a separate Inventory fact table that shares the Product dimension. A colleague suggests setting the Sales-to-Product relationship cross-filter direction to 'Both' to make this work. What is the most likely consequence of enabling bidirectional cross-filtering on this dimension relationship?

Accepted Answer

It can introduce ambiguous filter paths and unexpected results when multiple fact tables share the dimension, and may degrade query performance.

Answer

It automatically reduces the model size by eliminating duplicate dimension keys.

Answer

It converts the relationship to many-to-many cardinality, which is required for any shared dimension.

Answer

It forces all measures to recalculate using DirectQuery instead of the import cache.

Question 10

You are building a sales report page that must show either a clustered column chart or a matrix in the same screen area, letting users switch between them with a button. Both visuals already exist and are stacked in the same location. You want the button to hide one visual and show the other without navigating to a different page. What is the most reliable way to configure this toggle?

Accepted Answer

Create two bookmarks that each set the desired Selection pane visibility (one visual shown, the other hidden), uncheck Data in each bookmark, and assign one bookmark to a button's Action.

Answer

Use a single bookmark with Data enabled so the button also applies the current filter state when swapping visuals.

Answer

Add a page-level drillthrough filter and point the button's Action type to Drillthrough so the visuals alternate.

Answer

Sync a slicer across the two visuals and let the slicer selection determine which visual is displayed.

Question 11

A sales report page contains several slicers (Region, Product Category, and Fiscal Year) plus multiple visuals. Business users complain that after exploring the data they cannot quickly return the page to its default, unfiltered state. You want to add a single button that instantly clears all slicer selections and resets the page to its original view, without navigating away or reloading the report. What should you do?

Accepted Answer

Create a bookmark with the slicers cleared and 'Data' enabled, then assign it to a button using the Bookmark action.

Answer

Add a Page Navigator button that links back to the same report page.

Answer

Enable the 'Clear all' option in each slicer's header and instruct users to click it individually.

Answer

Create a drillthrough button that passes the current filter context to a duplicate reset page.

Question 12

You are building a sales report in Power BI. A [Total Sales] measure already exists and correctly sums the SalesAmount column. On a matrix visual, products are placed on rows and you need a measure named [% of All Products] that shows each product's sales as a percentage of the grand total across ALL products, so the value stays constant regardless of which product row it appears on. Which DAX definition should you use?

Accepted Answer

% of All Products = DIVIDE([Total Sales], CALCULATE([Total Sales], ALL('Product')))

Answer

% of All Products = DIVIDE([Total Sales], CALCULATE([Total Sales], ALLSELECTED('Product')))

Answer

% of All Products = DIVIDE([Total Sales], [Total Sales])

Answer

% of All Products = DIVIDE([Total Sales], CALCULATE([Total Sales], KEEPFILTERS('Product')))

Question 13

You maintain a sales model with a Sales fact table and a Date dimension. A report page is already filtered to show only the year 2023 via a page-level filter. A business user wants a card visual that always displays total sales for the full year 2024, regardless of any year filters applied elsewhere on the page. Which DAX measure will produce the correct result?

Accepted Answer

Sales 2024 = CALCULATE(SUM(Sales[Amount]), 'Date'[Year] = 2024)

Answer

Sales 2024 = CALCULATE(SUM(Sales[Amount]), FILTER('Date', 'Date'[Year] = 2024 && 'Date'[Year] = 2023))

Answer

Sales 2024 = SUMX(FILTER(Sales, RELATED('Date'[Year]) = 2024), Sales[Amount])

Answer

Sales 2024 = CALCULATE(SUM(Sales[Amount]), KEEPFILTERS('Date'[Year] = 2024))

Question 14

You maintain a Power BI model with 12 base measures (Total Sales, Total Cost, Total Profit, etc.). Business users want each measure to be viewable as Current, Year-to-Date (YTD), Prior Year, and Year-over-Year % without you creating 48 separate measures. You want a maintainable solution that applies these time-intelligence variations to any measure a user places on a visual. Which modeling feature should you implement?

Accepted Answer

Create a calculation group with calculation items for Current, YTD, Prior Year, and YoY % using SELECTEDMEASURE()

Answer

Create 48 explicit DAX measures, one for each combination of base measure and time variation

Answer

Add a role-playing date dimension and duplicate the model relationships for each time period

Answer

Create a field parameter that lists all 12 base measures so users can swap them on visuals

Question 15

You publish a semantic model to a workspace backed by Power BI Pro (shared capacity). The model imports data from an on-premises SQL Server through a data gateway. Business users need the data updated frequently throughout the business day, and you configure scheduled refresh. When you try to add refresh times, you find you cannot schedule more than eight refreshes in a single day. What is the most appropriate action to allow more frequent scheduled refreshes?

Accepted Answer

Move the workspace to a Premium (or Fabric) capacity, which supports up to 48 scheduled refreshes per day.

Answer

Switch the model's storage mode to DirectQuery so scheduled refresh limits no longer apply.

Answer

Replace the standard gateway with a personal gateway to bypass the shared-capacity refresh limit.

Answer

Enable large semantic model storage format on the model to raise the refresh limit.

Question 16

Your organization has a widely reused sales semantic model published to a Power BI workspace. The Center of Excellence has formally reviewed and validated the model as the authoritative source for company reporting. They want it to appear with a special badge in the OneLake data hub and the Datasets list so report authors trust it as the official version. As a workspace admin, what should you do to apply the highest level of trust indicator, and who must ultimately authorize it?

Accepted Answer

Set the endorsement to Certified from the semantic model settings, which only users authorized by the Fabric/Power BI admin in the tenant settings can apply.

Answer

Set the endorsement to Promoted from the semantic model settings; any workspace Member can do this.

Answer

Apply a Confidential sensitivity label to the model so it shows a trusted badge in the data hub.

Answer

Grant Build permission to all report authors, which automatically marks the model as Certified.

Question 17

You inherited a Power BI Desktop report that connects to an on-premises SQL Server. After the previous analyst left, the report fails to refresh with an authentication error because it still uses their stored Windows credentials. You need to update the connection to use a service account without rebuilding any queries. In Power BI Desktop, which action should you take?

Accepted Answer

Open File > Options and settings > Data source settings, select the SQL Server source, choose Edit Permissions, and update the credentials.

Answer

Delete all queries in Power Query Editor and re-create them so the new credentials are prompted.

Answer

Create a new parameter for the username and password and reference it in each query's connection string.

Answer

Change the storage mode of every table from Import to DirectQuery to force a credential prompt.

Question 18

You are building a Power BI model with a large fact table (Sales) that stays in DirectQuery mode against an Azure SQL Database for near-real-time reporting. A small Product dimension table is used both in slicers and in relationships with the DirectQuery fact table. Slicer interactions are slow because every selection sends a query to the source. You want fast slicer responses while still supporting efficient joins to the DirectQuery fact table. Which storage mode should you set on the Product table?

Accepted Answer

Set the Product table to Dual storage mode

Answer

Set the Product table to Import storage mode

Answer

Set the Product table to DirectQuery storage mode

Answer

Set the Product table to DirectLake storage mode

Question 19

You are building a Power BI report for a retail company. The fact data resides in a Microsoft Fabric lakehouse as Delta tables and totals over 500 million rows that are refreshed several times per day. Business users require near real-time reporting and interactive report performance similar to Import mode, but you must avoid duplicating the large dataset into the semantic model. Which storage mode should you use for the semantic model?

Accepted Answer

DirectLake mode over the lakehouse Delta tables

Answer

Import mode with an incremental refresh policy

Answer

DirectQuery mode connecting to the lakehouse SQL analytics endpoint

Answer

Composite mode with dual storage for all tables

Question 20

You are building a Power BI report for a manufacturing operations team that monitors a production database. The team requires that report visuals reflect changes in the source SQL Server database within seconds, and the dataset is far too large to fit into the model's memory. The organization does not use Microsoft Fabric. Which storage mode should you choose when connecting to the data?

Accepted Answer

DirectQuery mode

Answer

Import mode with a scheduled refresh every 15 minutes

Answer

Direct Lake mode

Answer

Import mode with incremental refresh

Question 21

You are building a report for the finance department from a SQL Server table containing 500,000 rows of historical monthly ledger entries. The data is updated only once per month during a scheduled batch job. Report users complain that similar reports connected live to the database render slowly, and there is no requirement for real-time data. Which storage mode should you choose to give users the fastest possible query and visual performance?

Accepted Answer

Import mode, refreshing the dataset after each monthly batch job

Answer

DirectQuery mode, so every visual reflects the latest database state

Answer

DirectLake mode connected directly to the SQL Server table

Answer

A live connection to a shared semantic model on the SQL Server

Question 22

You are analyzing a scatter chart in Power BI Desktop that plots each customer's total spend on the X axis against order frequency on the Y axis. Management wants Power BI to automatically identify natural groupings of customers with similar spending and frequency behavior so the marketing team can target distinct segments. You want to do this directly on the existing scatter chart without writing DAX or manually defining ranges. What should you do?

Accepted Answer

Use the '...' (More options) menu on the scatter chart and select Automatically find clusters.

Answer

Add a numeric grouping (bin) on the total spend field and rely on the bins to define segments.

Answer

Add the Key Influencers visual and set order frequency as the field to analyze.

Answer

Enable Anomaly detection in the Analytics pane to isolate outlier customers.

Question 23

You import a CSV file of product records into Power Query. A column named 'ProductCode' contains mostly numeric values in the first several hundred rows, but later rows include codes like 'X1050' and 'AB22'. Power Query automatically applied a Whole Number data type, and after loading you notice many ProductCode values appear as errors. What is the best way to prevent these import errors?

Accepted Answer

Remove the automatically added 'Changed Type' step and set the ProductCode column data type to Text

Answer

Use Replace Errors to substitute 0 for every error value in the ProductCode column

Answer

Increase the column profiling sample so type detection scans the entire dataset

Answer

Filter out the rows containing alphanumeric codes before the type change step

Question 24

You are profiling a 'ProductPrice' column in Power Query Editor. A stakeholder reports that a few products seem to have unusually high prices. You want to quickly see the exact minimum, maximum, and average values for the column, along with the count of distinct and unique values, without writing any code. Which Data Preview feature should you enable to display these summary statistics?

Accepted Answer

Column profile

Answer

Column quality

Answer

Column distribution

Answer

Show whitespace

Question 25

In Power Query Editor, you have a Customers table with an Email column containing values like "jsmith@contoso.com" and "mlee@fabrikam.net". You need to create a new column that contains only the domain portion (e.g., "contoso.com") for grouping customers by company. You are not confident writing the extraction expression manually. Which Power Query feature lets you build this transform by typing sample output values so the engine infers the M code?

Accepted Answer

Column from Examples

Answer

Column from Merge

Answer

Invoke Custom Function

Answer

Group By with a custom aggregation

Question 26

You are cleaning a 2-million-row sales table in Power Query Editor. You enable the Column quality and Column distribution features to check for data issues, but you notice the statistics seem to reflect only a small subset of rows. You need the profiling results to reflect all rows in the source before you finalize your cleaning steps. What should you do?

Accepted Answer

Change the column profiling setting at the bottom of the window from 'Column profiling based on top 1000 rows' to 'Column profiling based on entire data set'.

Answer

Increase the number of preview rows loaded by editing the 'Table.FirstN' step in the applied steps.

Answer

Disable Column quality and instead use the Data view statistics after loading the table to the model.

Answer

Add a 'Keep Top Rows' step set to 2,000,000 so the profiler evaluates every row.

Question 27

You are cleaning a 4-million-row sales table in Power Query Editor. In the status bar you enabled 'Column quality' and 'Column profile', but a colleague warns you that the error and empty percentages you see may not reflect the true state of the whole table. By default, what is the profiling based on, and what single action lets you validate the metrics against every row?

Accepted Answer

Profiling is based on the top 1,000 rows; click the profiling status message at the bottom and switch it to 'Column profiling based on entire data set'.

Answer

Profiling is based on the entire data set already; no change is needed because Power Query always scans all rows.

Answer

Profiling is based on a random 10% sample; disable and re-enable the Column profile checkbox to force a full scan.

Answer

Profiling is based on the top 1,000 rows; increase the sample by editing the 'Table.Profile' step in the Advanced Editor to pass all rows.

Question 28

You are cleaning a sales table in Power Query. After setting the 'UnitPrice' column to a Decimal Number type, the Column Quality pane shows 3% Error and 0% Empty. You need to investigate exactly which source values could not be converted before deciding how to handle them. What should you do first?

Accepted Answer

Right-click the error percentage in the Column Quality pane and select 'Keep Errors' to isolate the affected rows for inspection

Answer

Apply 'Remove Errors' on the UnitPrice column so the report can refresh without failure

Answer

Change the UnitPrice column type to Text so the values no longer generate conversion errors

Answer

Replace the error values with 0 using 'Replace Errors' before reviewing them

Question 29

You import an employee table into Power Query that contains separate FirstName and LastName columns. The business wants a single FullName column formatted as 'LastName, FirstName' (for example, 'Smith, Anna'), while keeping the original two columns intact for other reports. Which Power Query approach produces the required result with the least manual effort?

Accepted Answer

Add a custom column with the formula = [LastName] & ", " & [FirstName].

Answer

Select both columns and use Merge Columns with a custom separator of ', ', accepting the default column order.

Answer

Select both columns and use Format > Combine, then reverse the values with Split Column.

Answer

Use Group By on LastName and add an aggregated column that concatenates FirstName.

Question 30

You are building a Power BI report in Power Query. Your sales team exports one CSV file per month, each with identical columns (Date, ProductID, Quantity, Amount). You have 24 separate query connections, one per file, and need a single Sales fact table containing all rows from every month. Which transformation should you use to combine these queries most efficiently?

Accepted Answer

Append the queries to stack all rows into one table

Answer

Merge the queries using ProductID as the join key

Answer

Unpivot the columns in each query before combining

Answer

Group each query by Date and aggregate the Amount

Question 31

You are preparing a sales table in Power Query. Business users need a text column called 'Deal Size' that displays 'Large' when the OrderAmount is 10000 or greater, 'Medium' when it is between 1000 and 9999.99, and 'Small' otherwise. You want to build this using the Power Query Editor UI with the least amount of custom code. Which feature should you use?

Accepted Answer

Add a Conditional Column and define the if/then rules based on OrderAmount ranges

Answer

Add a Custom Column and write a nested SWITCH DAX expression

Answer

Use Column from Examples and type sample outputs for a few rows

Answer

Group By OrderAmount and add a text aggregation column

Question 32

You have a matrix visual showing monthly revenue by product category. Management wants each revenue cell shaded green when the value is at or above the category's target of 50,000, yellow between 30,000 and 49,999, and red below 30,000. The targets are fixed thresholds, not values stored in the model. You want the coloring to apply automatically as data refreshes. What is the most appropriate way to configure this?

Accepted Answer

Apply background color conditional formatting using the 'Rules' formatting style, defining explicit numeric ranges for each color band

Answer

Apply background color conditional formatting using the 'Color scale' (gradient) formatting style with a minimum and maximum color

Answer

Create three separate measures returning fixed color hex codes and place all three in the matrix values

Answer

Manually select and shade each qualifying cell using the format cell background option after every refresh

Question 33

You have a matrix visual showing monthly revenue by product category. Management wants each revenue cell to display a horizontal bar whose length is proportional to the value, while still showing the numeric revenue text inside the same cell so users can read exact figures. What is the most efficient way to achieve this?

Accepted Answer

Apply conditional formatting of type 'Data bars' to the revenue field in the matrix values.

Answer

Add a background color conditional formatting rule based on the revenue value.

Answer

Replace the matrix with a clustered bar chart and remove the numeric labels.

Answer

Create a measure that returns a Unicode block-character string sized by value and place it beside the revenue.

Question 34

A financial report includes a matrix showing monthly profit values by region. Management wants any negative profit value to appear in red text and positive values in green, based directly on each cell's own value. You want the color to update automatically as data refreshes without creating extra measures if avoidable. Which conditional formatting approach in the Format pane should you use for the profit field?

Accepted Answer

Apply 'Font color' conditional formatting using the 'Rules' format style based on the profit field value

Answer

Apply 'Data bars' conditional formatting to the profit values

Answer

Apply 'Background color' using the 'Gradient' format style based on a separate rank measure

Answer

Use a report-level theme JSON file to set default font colors for the visual

Question 35

You build a matrix that shows each store's monthly revenue. Management wants a visual status indicator next to each revenue value: a green up-arrow when revenue meets or exceeds a target measure [Target], a yellow dash when it is within 10% below target, and a red down-arrow when it is more than 10% below target. You must implement this without adding extra columns to the table and without a separate visual. What should you do?

Accepted Answer

Apply conditional formatting Icons to the revenue field, using rules based on a measure that returns the ratio of revenue to [Target].

Answer

Add a KPI visual next to the matrix and set the target to [Target] with a good/neutral/bad color range.

Answer

Apply conditional formatting Background color to the revenue field with three color rules comparing revenue to [Target].

Answer

Create three separate measures returning arrow emoji text and place them in adjacent matrix value fields.

Question 36

A report contains a table listing support tickets. One text column, TicketLink, stores full URLs pointing to each ticket in an external system. Currently the cells display the raw URL text, but stakeholders want each row to show a clickable hyperlink labeled with the ticket subject instead of the long URL. What should you configure?

Accepted Answer

Apply conditional formatting > Web URL on the ticket subject column, pointing it to the TicketLink field

Answer

Set the TicketLink column's Data category to Web URL in the model

Answer

Enable the 'URL icon' toggle in the table's Values formatting card

Answer

Create a custom tooltip page that displays the TicketLink field on hover

Question 37

You are designing an executive report page that contains a large sales matrix and four small KPI cards. Executives have asked that, when they click a 'Focus Sales' button, the entire page should dim except for the sales matrix, which should remain fully visible and prominent. Clicking a 'Reset View' button should return the page to normal. You want to implement this with the least effort and without hiding any visuals. Which approach should you use?

Accepted Answer

Apply the Spotlight feature to the matrix, capture it in a bookmark for the Focus button, and capture the default state in a bookmark for the Reset button.

Answer

Set the KPI cards to hidden in a bookmark assigned to the Focus button, and show them again in the Reset bookmark.

Answer

Use drillthrough from the matrix to a dedicated detail page that contains only the sales matrix.

Answer

Create a duplicate report page containing only the matrix and use page navigation buttons to switch between the two pages.

Question 38

You are building a Power BI report for a sales team that stores its CRM data in Microsoft Dataverse. The team requires that report data refresh on a schedule and that queries perform efficiently against many related tables. You want to use the most appropriate connectivity option in Power BI Desktop. Which approach should you use to connect to the data?

Accepted Answer

Use the built-in Dataverse connector in Get Data and select the required tables.

Answer

Use the Web connector and point it at the Dataverse OData feed URL manually.

Answer

Export each Dataverse table to a CSV file and import the files with the Folder connector.

Answer

Use the SQL Server connector pointing at the on-premises data gateway.

Question 39

Your organization has a certified shared semantic model in the Power BI service that contains cleaned sales data, standardized measures, and a defined date dimension. A new analyst needs to build several additional reports using this same data and must ensure the reports always reflect the single governed version of the model without duplicating the data or the business logic. What should the analyst do in Power BI Desktop?

Accepted Answer

Use Get Data and select the Power BI semantic models connector to create a live connection to the shared semantic model

Answer

Import the underlying tables from the original source database and recreate the measures locally

Answer

Export the shared semantic model to a .pbix file and import its tables using Import mode

Answer

Connect to the shared semantic model using DirectQuery so the report queries the source in real time

Question 40

A financial reporting model imports a 60-million-row fact table. Refreshes are slow and the .pbix file is very large. Using DAX Studio's VertiPaq Analyzer, you find that a single column, OrderDateTime (stored as date/time with second-level precision), consumes the largest share of model memory. Reports only ever aggregate sales by day, month, and year — never by time of day. Which action reduces model size while preserving all required reporting capability?

Accepted Answer

Change the OrderDateTime column's data type to Date so the time portion is dropped, collapsing distinct values.

Answer

Set the OrderDateTime column's Summarize By property to Do Not Summarize.

Answer

Hide the OrderDateTime column from Report view so it no longer loads into memory.

Answer

Switch the fact table's storage mode to DirectQuery to avoid importing the column.

Question 41

You publish a sales report to a Power BI workspace in a Premium capacity. The regional managers who consume the report have asked for a plain-language paragraph at the top of the overview page that automatically describes total sales, top-performing region, and month-over-month change, and that updates as they apply their own slicer selections. You want to add this with minimal manual authoring effort. Which report element should you add?

Accepted Answer

A Smart narrative visual placed on the page

Answer

A text box with a static summary you type manually

Answer

A Key influencers visual configured with sales as the analyze field

Answer

A card visual showing the total sales measure only

Question 42

You are building a Power BI report in Power BI Desktop connected to a well-structured sales semantic model. Your manager asks you to quickly generate a first-draft report page that summarizes revenue by region and product category so the team can start reviewing layout ideas. You want to use Copilot to accelerate this initial page build. Before Copilot can create a report page from your natural-language prompt, which prerequisite must be satisfied?

Accepted Answer

The workspace must be assigned to a Fabric or Power BI Premium (F/P SKU) capacity that has Copilot enabled.

Answer

The report must first contain at least one manually created visual on the target page.

Answer

The semantic model must be set to DirectQuery storage mode so Copilot can query live data.

Answer

A report theme JSON file must be applied so Copilot knows which colors to use.

Question 43

You are building an executive sales report in Power BI Desktop with Copilot enabled in your Fabric workspace. Leadership wants a text block on the summary page that automatically writes a short paragraph describing the key totals and trends shown by the visuals on that page, and that updates its wording as users apply slicers. Which approach should you use?

Accepted Answer

Add a Copilot narrative visual and let it generate a summary of the page's visuals, allowing it to update with filter context

Answer

Insert a static text box and type the summary paragraph manually, updating it before each publish

Answer

Add a Card visual for each metric so the numbers appear individually on the page

Answer

Use the Key influencers visual to explain which factors drive the sales totals

Question 44

You maintain a Power BI model with a Sales fact table and a Customer dimension joined on CustomerKey (one-to-many, single cross-filter). Management wants a measure that returns the number of unique customers who placed at least one order, so the value must respect any slicers applied to product, date, or region. Which DAX measure correctly meets this requirement?

Accepted Answer

Active Customers = DISTINCTCOUNT(Sales[CustomerKey])

Answer

Active Customers = COUNTROWS(Customer)

Answer

Active Customers = DISTINCTCOUNT(Customer[CustomerKey])

Answer

Active Customers = CALCULATE(COUNT(Customer[CustomerKey]), ALL(Sales))

Question 45

You maintain a Power BI model with a fact table named Sales containing a [Total Sales] measure, and a marked Date table related to Sales on the OrderDate column. Management wants a measure that shows the running total of sales from the first day of the fiscal year (starting July 1) through the current date in the report context. Which DAX expression should you use?

Accepted Answer

CALCULATE([Total Sales], DATESYTD('Date'[Date], "6/30"))

Answer

CALCULATE([Total Sales], TOTALYTD('Date'[Date]))

Answer

CALCULATE([Total Sales], DATESYTD('Date'[Date], "7/1"))

Answer

CALCULATE([Total Sales], SAMEPERIODLASTYEAR('Date'[Date]))

Question 46

A sales manager reviews a bar chart showing total revenue by product category. She wants that when users hover over any bar, a rich pop-up appears showing a mini trend line of monthly revenue plus the top customer for that category, instead of the default single-value tooltip. What is the correct way to implement this in Power BI Desktop?

Accepted Answer

Create a report page, size it to Tooltip in Page Information, add the trend line and customer visuals, then set the bar chart's Tooltip property to that page

Answer

Add the additional fields to the Tooltips field well of the bar chart so they appear in the default tooltip

Answer

Enable the 'Report page tooltips' toggle in Options and add the visuals directly onto the main report canvas

Answer

Create a bookmark containing the trend line and customer visuals and assign it to the bar chart's hover action

Question 47

You built a dedicated report page containing a card and a small line chart, then set its page type to 'Tooltip' in the Page Information settings. When you hover over data points on a bar chart on your main page, the default tooltip still appears instead of your custom tooltip page. What must you do so the custom tooltip page displays for the bar chart?

Accepted Answer

In the bar chart's Format pane, turn on the Tooltip option and set its Type to 'Report page', then select your tooltip page.

Answer

Add the bar chart's category field as a page-level filter on the tooltip page.

Answer

Enable 'Allow use as tooltip' in the report-level settings and republish the report.

Answer

Set the tooltip page's Page size to 'Type: Tooltip' and hide the page from the page tabs.

Question 48

You publish a dashboard that includes a card visual tracking daily total revenue. The finance director wants to be notified automatically whenever total revenue on that card falls below $50,000, and she wants the notification pushed to the Power BI mobile app on her phone. What should you configure?

Accepted Answer

A data alert on the card tile in the dashboard, with a threshold condition of below $50,000

Answer

An email subscription to the dashboard page set to send daily snapshots

Answer

Row-level security so only the director sees revenue below $50,000

Answer

A scheduled refresh on the semantic model set to run whenever revenue drops

Question 49

You publish a dashboard to a Power BI workspace backed by a Premium capacity. You need to share the dashboard with a partner organization's user whose email is on a different Azure AD tenant. The partner must be able to view the dashboard but not modify it, and your organization has already enabled external sharing in the tenant admin settings. What is the correct approach?

Accepted Answer

Share the dashboard directly with the partner's email address; Power BI invites them as an Azure AD B2B guest and grants read-only access.

Answer

Add the partner's email to the workspace as a Viewer role member so they can open the dashboard.

Answer

Publish the workspace as an app and add the partner as a Contributor in the app audience.

Answer

Export the dashboard as a PDF and email it to the partner because external tenants cannot access Power BI content.

Question 50

You manage a Power BI workspace containing several dashboards and reports. The finance director asks to receive an automatic email every Monday morning that includes a static image of a specific dashboard so she can review key metrics before her weekly meeting, without opening Power BI. You have Pro licenses for all involved users. What should you configure to meet this requirement with the least administrative effort?

Accepted Answer

Create a subscription on the dashboard, set the frequency to Weekly on Mondays, and add the finance director as a recipient.

Answer

Set up a scheduled refresh on the underlying semantic model and enable refresh failure notifications for the finance director.

Answer

Create a data alert on a dashboard tile and configure it to email the finance director every Monday.

Answer

Export the dashboard to PDF manually each Monday and email it to the finance director.

Question 51

A colleague who published a semantic model to a Power BI workspace has left the company, and their account has been disabled. The model's scheduled refresh is now failing because the stored data source credentials belonged to that person. You are a Member of the workspace and need to get scheduled refresh working again with your own credentials, with the least administrative effort. What should you do first?

Accepted Answer

Take over the semantic model from its settings page, then re-enter the data source credentials.

Answer

Ask a Power BI administrator to reassign the entire workspace to a new capacity.

Answer

Delete the semantic model and republish it from the original .pbix file.

Answer

Add your account to the data source's users list in the on-premises data gateway.

Question 52

You manage a semantic model that imports 5 years of sales transactions, totaling over 200 million rows, from an Azure SQL Database. Full daily refreshes now exceed the refresh time window and frequently fail. Only the most recent 10 days of data ever changes at the source; older data is static. You must reduce refresh duration and reliability issues while keeping historical data available. What should you configure?

Accepted Answer

An incremental refresh policy that stores 5 years of data and refreshes only the last 10 days

Answer

A second scheduled refresh at a different time of day to spread the load

Answer

DirectQuery storage mode for the fact table to eliminate the import refresh entirely

Answer

A gateway cluster with additional gateway members to increase refresh throughput

Question 53

You are optimizing a large sales semantic model in Power BI Desktop. Before finalizing, you want to inspect the actual row count and a sample of data returned by a new intermediate table variable used inside several measures, without adding a visual to a report page. You open the DAX query view. Which DAX construct should you write to return the sample rows of the underlying calculation for inspection?

Accepted Answer

An EVALUATE statement wrapping a TOPN over the SUMMARIZECOLUMNS expression

Answer

A DEFINE MEASURE block referencing the visual's implicit measure

Answer

A CALCULATE expression assigned to a new calculated column

Answer

An ORDER BY clause placed before the EVALUATE keyword

Question 54

You maintain an imported Power BI semantic model that has grown to 1.2 GB, causing slow refreshes and high memory use. Before removing anything, you want to identify which specific columns consume the most storage so you can target the largest offenders. Which approach gives you the most precise, column-level size breakdown?

Accepted Answer

Run VertiPaq Analyzer (via DAX Studio or the model's memory statistics) to view the size in bytes of each column, table, and dictionary

Answer

Use Performance Analyzer to capture the DAX query duration for each visual on the report canvas

Answer

Open Column quality and Column distribution in Power Query to review the percentage of valid and unique values

Answer

Enable Assume referential integrity on each relationship to compress the model automatically

Question 55

A sales manager wants an interactive visual where they can start from total revenue and progressively break it down by dimensions of their choosing (such as Region, then Product Category, then Salesperson). They also want Power BI to automatically suggest which dimension explains the highest or lowest values at each level. Which visual should you add to the report?

Accepted Answer

Decomposition tree visual

Answer

Key influencers visual

Answer

Q&A visual

Answer

Clustered column chart with a hierarchy slicer

Question 56

Your team maintains a Power BI workspace named 'Sales Analytics Prod' that already contains published reports and semantic models used by hundreds of users. You want to introduce a structured release process using a deployment pipeline with Development, Test, and Production stages, without disrupting the existing content or its consumers. What is the correct approach to bring the existing production workspace into a deployment pipeline?

Accepted Answer

Create a new deployment pipeline and assign the existing 'Sales Analytics Prod' workspace to the Production stage, then deploy backward to populate Test and Development.

Answer

Delete the existing workspace, create three new workspaces, and re-import all content into the Development stage before deploying forward.

Answer

Assign the existing 'Sales Analytics Prod' workspace to the Development stage and let the pipeline automatically move it to Production.

Answer

Publish the existing content directly into the pipeline without assigning any workspace to a stage.

Question 57

Your team uses a Power BI deployment pipeline with Development, Test, and Production stages. Before promoting content from Test to Production, a governance policy requires you to verify exactly which reports and semantic models differ between the two stages. Which capability should you use to identify these differences without opening each item individually?

Accepted Answer

Use the pipeline's compare feature, which shows the change indicator between adjacent stages

Answer

Configure parameter rules on the Production stage to override differing values

Answer

Enable a scheduled refresh on both stages and compare the refresh history logs

Answer

Export both workspaces as .pbix files and diff them with an external comparison tool

Question 58

You publish a Power BI app to 200 users in the Sales workspace. Two weeks later you update a report's layout and correct a measure in the underlying semantic model. Business users report they still see the old version of the report. What must you do so the changes reach the app audience?

Accepted Answer

Republish (update) the app from the workspace

Answer

Trigger an on-demand refresh of the semantic model

Answer

Grant the users the Viewer workspace role

Answer

Reshare the report link with the users individually

Question 59

Your organization uses a Power BI deployment pipeline with Development, Test, and Production stages, each mapped to a separate workspace. A group of report developers must be able to build content and promote items from Development to Test, but they must NOT be able to deploy to the Production stage or modify content in the Production workspace. Only two release managers should perform deployments into Production. What is the recommended way to enforce this?

Accepted Answer

Grant the developers pipeline access plus Member/Admin roles on the Development and Test workspaces only, and grant the two release managers workspace access on Production.

Answer

Assign the developers the Admin role on all three workspaces and rely on deployment pipeline access to control who deploys.

Answer

Add all developers as Contributors on the Production workspace and remove them from the deployment pipeline entirely.

Answer

Configure row-level security roles in the Production semantic model to block developers from deploying.

Question 60

Your team uses a Power BI deployment pipeline with Development, Test, and Production stages. A semantic model in Development has three row-level security (RLS) roles defined, each with DAX filter expressions but no members assigned. After deploying to Test, a security administrator manually assigns Azure AD security groups to each role in the Test workspace. The next week you deploy an updated model from Development to Test again. What happens to the RLS role membership assignments in the Test stage after this second deployment?

Accepted Answer

The role definitions (DAX filters) are updated, but the member assignments made in Test are preserved.

Answer

Both the DAX filter expressions and the member assignments are overwritten with the Development values (which have no members).

Answer

The deployment fails because RLS roles already have members assigned in the target stage.

Answer

The member assignments are copied back from Test to Development to keep both stages synchronized.

Question 61

Your team uses a Power BI deployment pipeline with Development, Test, and Production stages. A developer has finished validating a semantic model and report in the Test stage. The changes must now be moved to Production, but only the report has been modified since the last deployment—the semantic model is unchanged. You want the fastest deployment while ensuring the Production semantic model's existing data source connection and scheduled refresh settings are preserved. What should you do?

Accepted Answer

Select only the report item in the Test stage and deploy it to Production, leaving the semantic model unselected.

Answer

Delete the Production workspace content and republish everything from Power BI Desktop.

Answer

Deploy all items from Test to Production and reconfigure the data source credentials afterward.

Answer

Copy the report from the Test workspace manually and paste it into the Production workspace.

Question 62

You are cleaning a customer dataset in Power Query. Before building relationships, you want to verify that the CustomerID column contains only unique values and identify how many distinct and duplicate values exist. Which column profiling feature in the Power Query Editor should you enable to see this information at a glance?

Accepted Answer

Column distribution, which shows distinct and unique value counts for the column

Answer

Column quality, which shows the percentage of valid, error, and empty values

Answer

Column profile, which shows detailed statistics such as min, max, and average

Answer

Monospaced font in the data preview, which aligns values for visual scanning

Question 63

You import a supplier delivery table into Power Query. Before building the model, you want a quick per-column indicator that shows what percentage of rows in the preview are valid, contain errors, or are empty, so you can decide which columns need cleaning first. Which Power Query feature should you enable in the View ribbon to see this at a glance?

Accepted Answer

Column quality

Answer

Column distribution

Answer

Column profile

Answer

Monospaced (Value distribution formatting)

Question 64

You import a Product table into Power Query. The Category column contains values such as "Bikes", "bikes", "BIKES", and " Bikes" (with leading spaces). A report grouping by Category shows four separate groups that should all be one. Which combination of Power Query transformations will consolidate these into a single consistent value with the least manual effort?

Accepted Answer

Apply Trim to remove surrounding spaces, then apply Capitalize Each Word (or lowercase/uppercase) to standardize casing on the Category column

Answer

Use Replace Values four times, once for each distinct spelling, mapping every variant to "Bikes"

Answer

Change the column data type to Text and enable Column Quality profiling to auto-correct the values

Answer

Remove Duplicates on the Category column so only one version of each value remains

Exam domain	Exam weight	Practice
Prepare the data	27%	Practice this topic
Model the data	27%	Practice this topic
Visualize and analyze the data	27%	Practice this topic
Manage and secure Power BI	19%	Practice this topic

Microsoft Power BI Data Analyst (PL-300) practice exam & study guide

Start studying PL-300

All PL-300 study resources

PL-300 exam domains

Sample PL-300 questions

Key PL-300 terms

PL-300 frequently asked questions

Prepare the data (27%)

Model the data (27%)

Visualize and analyze the data (27%)

Manage and secure Power BI (19%)