Microsoft PL-300: Microsoft Power BI Data Analyst

Last checked October 22, 2026 against the official Microsoft exam page.

1. Question 1Model the data

   A Sales fact table has many rows per product, and each product appears once in a Products table. How should the relationship be defined?

   1. AMany-to-one from Sales to Products with both filter directions
   2. BOne-to-many from Products to Sales with single filter direction
   3. CMany-to-many from Sales to Products with both filter directions
   4. DOne-to-one from Products to Sales with single filter direction
   Show answer and explanationHide answer

   Correct answer: B

   Products is the one side and Sales is the many side, so filters should flow from Products to Sales. Many-to-many and one-to-one do not match this grain, and bidirectional filtering is not needed in a standard star schema.

2. Question 2Visualize and analyze the data

   A line chart of monthly revenue must show a forecast for the next six months. Which feature should you use?

   1. ADecomposition tree with a constant baseline reference line
   2. BForecast in the Analytics pane of the line chart
   3. CTrend line on a scatter chart with linear regression
   4. DKey influencers visual with forecast setting enabled
   Show answer and explanationHide answer

   Correct answer: B

   The Forecast option in the Analytics pane extends a line chart's series into future periods. A scatter trend line is a fitted line, a decomposition tree breaks down a measure, and key influencers ranks factors rather than forecasting.

3. Question 3Deploy and maintain assets

   Which two conditions must be met for a Pro user to view a report shared from a Pro workspace? (Choose two.)

   1. AThe report is published to web with an embed code
   2. BThe viewer holds a Pro or Premium Per User license
   3. CThe report is shared with the viewer or the viewer has a workspace role
   4. DThe report is exported to PDF and emailed to the viewer
   5. EThe dataset is set to DirectQuery only
   Show answer and explanationHide answer

   Correct answer: B, C

   Viewing Pro content requires a per-user license and access to the content through sharing or a workspace role. Exporting to PDF, DirectQuery storage mode and publish to web do not grant or define that access.

4. Question 4Prepare the data

   A Sales table imported from Excel stores OrderDate as text in the format 31/12/2025, which is day-first. What should you do in Power Query so the column becomes a true date?

   1. AChange the column type to Date using the Using Locale option with English (United Kingdom)
   2. BChange the column type to Date/Time/Timezone so the time zone is applied to the parsed date values
   3. CAdd a custom column that uses Number.From to convert the text values into numeric serial numbers for loading
   4. DReplace the values with a DAX CALENDAR table generated in the model with CALENDARAUTO to derive the dates
   Show answer and explanationHide answer

   Correct answer: A

   Change Type with Locale tells Power Query how to parse day-first text. Date/Time/Timezone adds a time component and zone, and Number.From returns a number, so neither fixes the parsing.

5. Question 5Model the data

   A measure must return total sales while ignoring any filter applied to the Region table but keeping filters on other tables. Which expression should you use?

   1. ACALCULATE([Total Sales], REMOVEFILTERS(Region))
   2. BCALCULATE([Total Sales], VALUES(Region))
   3. CCALCULATE([Total Sales], KEEPFILTERS(Region))
   4. DSUMX(Region, CALCULATE([Total Sales]))
   Show answer and explanationHide answer

   Correct answer: A

   REMOVEFILTERS clears the filters on the named table only. VALUES and KEEPFILTERS keep the Region filter in place, and SUMX iterates rows without removing the existing context.