PL-300: Microsoft Power BI Data Analyst

PL-300 exam objectives and study guide

The skills measured on the PL-300 exam, by objective domain. Percentages are the share of the exam each domain carries.

PL-300 practice questions and answers

10 free sample questions from the PL-300 bank, with the correct answer and a full explanation for each. These are original questions written to the Microsoft objective domains — not real exam content.

1. Question 1Manage and secure Power BI

   Samira, a compliance analyst, must let report authors classify reports and semantic models in Power BI by using Confidential and Highly Confidential labels that are already published to them in Microsoft Purview. The authors have the required licensing and can apply the same labels in Office apps, but the labels do not appear in Power BI Desktop or the Power BI service. What should the Power BI administrator configure?

   • AEnable the tenant setting named Allow users to apply sensitivity labels for Power BI content for the authors.
   • BEnable built-in sensitivity labeling for Office files in SharePoint and OneDrive for the tenant.
   • CAdd the authors to the Admin role in each workspace that contains labeled reports and semantic models.
   • DConfigure the labels to use only the container scope for Teams, Microsoft 365 Groups, and SharePoint sites.

   Show answer and explanation

   Correct answer

   • Enable the tenant setting named Allow users to apply sensitivity labels for Power BI content for the authors.

   Explanation

   The correct answer is to enable the Power BI tenant setting Allow users to apply sensitivity labels for Power BI content for the appropriate users or security groups. Publishing labels in Microsoft Purview makes the labels available to users, but Power BI must also be enabled to use sensitivity labels.

   • Enabling sensitivity labels for SharePoint and OneDrive affects Office files stored in those services; it does not enable labeling for Power BI items.
   • Adding authors to the workspace Admin role grants workspace management permissions, but it does not make Purview labels appear when the Power BI tenant setting is disabled.
   • Container label scope is used for Teams, Microsoft 365 Groups, SharePoint sites, and similar containers, not for applying labels to Power BI reports or semantic models.

   References:

   • How to apply sensitivity labels in Power BI
   • Learn about sensitivity labels
2. Question 2Manage and secure Power BI

   You administer the Power BI tenant. Report creators can see the organization's Confidential labels in Word and Excel, but they cannot apply those labels to reports or semantic models in Power BI. You need to make the existing labels available for manual labeling in Power BI service and Power BI Desktop. What should you do?

   • AEnable Allow users to apply sensitivity labels for Power BI content in the Power BI tenant settings for the creators.
   • BEnable Apply sensitivity labels from data sources to their data in Power BI in the tenant settings for the creators.
   • CConfigure Exchange Online IRM so encrypted labels are available in Outlook on the web and mobile clients.
   • DGrant the creators the Admin workspace role in each workspace that contains reports and semantic models.

   Show answer and explanation

   Correct answer

   • Enable Allow users to apply sensitivity labels for Power BI content in the Power BI tenant settings for the creators.

   Explanation

   Enable the Power BI tenant setting Allow users to apply sensitivity labels for Power BI content for the report creators. The labels are already published to the users because they can see them in Office apps; the missing requirement is enabling Power BI to use sensitivity labels.

   The data-source inheritance setting is for automatically applying labels from supported sources to Power BI data; it does not enable the manual labeling UI by itself. Exchange Online IRM is for encrypted email scenarios. Workspace Admin permission can allow editing workspace content, but it does not make Purview sensitivity labels available in Power BI when the tenant setting is disabled.

   References:

   • How to apply sensitivity labels in Power BI
   • Learn about sensitivity labels
3. Question 3Manage and secure Power BI

   During an endorsement training session, authors ask which actions they can take without involving the governance group. Which two statements are accurate for Power BI endorsements?

   • AA user with write permission on an item can promote the item without being in the certification security group.
   • BA user can certify an item only when certification is enabled for that user or group and the user has write permission.
   • CThe Viewer workspace role plus Build permission is sufficient to promote or certify a semantic model.
   • DCertification automatically grants consumers Build permission on the underlying semantic model.
   • EApplying a sensitivity label is the supported way to mark content as officially endorsed.

   Show answer and explanation

   Correct answers

   • A user with write permission on an item can promote the item without being in the certification security group.
   • A user can certify an item only when certification is enabled for that user or group and the user has write permission.

   Explanation

   Promotion and certification use different trust levels and permission requirements.

   • A user with write permission can promote content without being in the certification security group.
   • Certification requires the tenant certification setting to allow the user or group and also requires write permissions on the item.
   • Viewer plus Build lets a user consume or create content from a semantic model, but it is not write permission for endorsement management.
   • Certification does not automatically grant Build permission to consumers; permissions are managed separately.
   • Sensitivity labels classify and protect data, but they are not the mechanism for Power BI endorsement.

   References:

   • Build Permission for Shared Semantic Models
4. Question 4Manage and secure Power BI

   Margie's Travel publishes a departmental report that analysts find useful, but the central BI team has not reviewed it for enterprise certification. Which endorsement should the report owner apply?

   • APromoted
   • BCertified
   • CSensitivity label
   • DWorkspace app

   Show answer and explanation

   Correct answer

   • Promoted

   Explanation

   Promoted is the appropriate endorsement when a content owner wants to highlight useful content that has not gone through the organization's formal certification process.

   • Certified is for content that has passed the organization's defined review and can be applied only by authorized certifiers.
   • A sensitivity label classifies or protects data; it is not an endorsement.
   • Publishing an app distributes content, but it does not mark the report as promoted or certified.

   References:

   • Promote and Certify Power BI Content with Endorsement
5. Question 5Visualize and analyze the data

   For a production-quality dashboard, Mateo must chart daily defect rate by production line. Each data point needs an asymmetric uncertainty interval from the measures `Defect Rate Low` and `Defect Rate High`, and the visual must also show a tolerance limit at 0.02. The solution must respond to slicers and must not use manually drawn shapes. Which two actions should he take?

   • AEnable Error bars and assign `Defect Rate Low` as the lower bound and `Defect Rate High` as the upper bound.
   • BAdd a Y-axis constant line at 0.02 and label it with the tolerance limit.
   • CUse a forecast with a 95 percent confidence interval to draw the uncertainty range on historical points.
   • DAdd Min line and Max line reference lines to represent every point's lower and upper interval.
   • EAdd `Defect Rate Low` and `Defect Rate High` to the Y-axis field well as two additional line series.

   Show answer and explanation

   Correct answers

   • Enable Error bars and assign `Defect Rate Low` as the lower bound and `Defect Rate High` as the upper bound.
   • Add a Y-axis constant line at 0.02 and label it with the tolerance limit.

   Explanation

   Use error bars when the lower and upper bounds are already available as measures for each data point. Use a Y-axis constant line for the fixed tolerance limit. Both are report visual features that respond appropriately to the visual context, while avoiding manual shapes.

   • Forecast confidence intervals are for projected future values on a time series, not for the historical interval around each plotted point.
   • Min and Max reference lines calculate whole-visual summary lines; they do not use the supplied lower and upper measures for each point.
   • Adding low and high measures as additional Y-axis series creates extra lines, not error bars attached to the defect-rate points.

   References:

6. Question 6Visualize and analyze the data

   Fourth Coffee's regional managers ask for a report visual that marks a fixed daily sales quota across the plotted values and another visual that projects future weekly sales from a historical time series. Which two Power BI features are appropriate?

   • AAdd a Y-axis constant line to the visual.
   • BAdd a forecast to a supported line chart.
   • CAdd a report-level slicer for the date field.
   • DCreate a drillthrough page by store.
   • EUse the decomposition tree visual.

   Show answer and explanation

   Correct answers

   • Add a Y-axis constant line to the visual.
   • Add a forecast to a supported line chart.

   Explanation

   A Y-axis constant line is a reference line used to mark a fixed threshold or quota on a visual. A forecast on a supported line chart projects future values from the historical series.

   • A slicer filters report data but does not mark a quota or project future values.
   • A drillthrough page provides navigation to detail, not a visual reference line or projection.
   • A decomposition tree helps explain contributions to a metric, not create a time-series forecast.

   References:

   • Overview of visualizations in Power BI
7. Question 7Visualize and analyze the data

   Sofia is redesigning a monthly gross margin line chart. Leadership wants two horizontal markers that recalculate under product and region slicers: the mean margin for the visible months and the median margin for the visible months. No new DAX measures should be created. Which configuration should she use?

   • ASelect the visual and add an Average line and a Median line from the Analytics pane.
   • BAdd two Y-axis constant lines and type the current mean and median values as fixed numbers.
   • CEnable Error bars and set the lower and upper bounds to the gross margin measure.
   • DAdd a forecast with Seasonality set to Auto and Confidence interval set to 95 percent.
   • EAdd a month slicer and turn on major gridlines for the Y-axis.

   Show answer and explanation

   Correct answer

   • Select the visual and add an Average line and a Median line from the Analytics pane.

   Explanation

   Average and Median lines in the Analytics pane are dynamic reference lines for the selected visual. They calculate from the values currently visible in the visual context and update when filters or slicers change.

   • Manually typed constant lines are fixed values and would not automatically recalculate to the visible mean and median.
   • Error bars represent uncertainty or upper and lower bounds for data points; they are not mean and median reference markers.
   • Forecasting projects future values and confidence intervals; it does not add current mean and median markers.
   • Gridlines and slicers can improve navigation or filtering, but they do not create the required analytic markers.

   References:

8. Question 8Visualize and analyze the data

   During the weekly operations review, stakeholders use a daily ticket-volume line chart. They want a marker for the 90th percentile of the visible historical days and a four-week projection with an uncertainty band. They do not need measurement uncertainty around each historical point. Which two additions meet the requirements?

   • AAdd a Percentile line in the Analytics pane and set the percentile to 90.
   • BAdd a Forecast in the Analytics pane and set the length to four weeks.
   • CEnable Error bars by field with separate lower and upper bound measures.
   • DAdd a Y-axis constant line using the 90th percentile value from the last dataset refresh.
   • EAdd Min line and Max line reference lines to the line chart.

   Show answer and explanation

   Correct answers

   • Add a Percentile line in the Analytics pane and set the percentile to 90.
   • Add a Forecast in the Analytics pane and set the length to four weeks.

   Explanation

   A Percentile line is the appropriate dynamic reference line for the 90th percentile of visible historical values. A Forecast adds projected future values and the confidence band to a supported line chart.

   • Error bars by field would show uncertainty around existing data points, which the stakeholders explicitly do not need.
   • A manually entered constant line based on the last refresh would not recalculate for the visible filtered days.
   • Min and Max lines show the range endpoints, not the 90th percentile or a future projection.

   References:

9. Question 9Visualize and analyze the data

   Ravi, a sales analyst, must make a clustered column chart show the exact monthly revenue total directly above each column. The chart already has Month on the x-axis and Revenue in the y-axis. Which visual formatting option should Ravi enable?

   • ATurn on Data labels in the Format visual pane.
   • BTurn on Error bars in the Analytics section.
   • CMove Revenue to the Tooltips field well.
   • DEnable Legend and set its position to Top.
   • EFormat the X-axis values and increase the text size.

   Show answer and explanation

   Correct answer

   • Turn on Data labels in the Format visual pane.

   Explanation

   The Data labels setting displays the measure value directly on or near each data point, such as above each column in a column chart.

   • Legend identifies series, but it does not show each column's numeric value.
   • Tooltips show values only when users hover over data points.
   • Error bars communicate uncertainty or bounds, not the actual value label.
   • X-axis values format category labels such as months, not revenue totals.

   References:

   • Customize Power BI Visualization Titles
10. Question 10Visualize and analyze the data

    A monthly executive page needs a line chart title that reads Revenue trend for followed by the selected month. If more than one month is selected, the title must read Revenue trend for all selected months. Complete the DAX measure that will be used for conditional formatting of the visual title text.

    Selected Month Title =
    "Revenue trend for " &
    1('Date'[Month], "all selected months")

    Blank 1

    • ASELECTEDVALUE
    • BVALUES
    • CFIRSTNONBLANK
    • DCONCATENATEX

    Show answer and explanation

    Correct answer

    • Blank 1: SELECTEDVALUE

    Explanation

    SELECTEDVALUE(column, alternateResult) returns the single selected value for a column, or the alternate result when zero or multiple values are selected. That behavior matches the dynamic title requirement.

    • VALUES returns a table of distinct values and is not the scalar title function needed here.
    • FIRSTNONBLANK returns the first nonblank value based on an expression; it does not implement the alternate result for multiple selections.
    • CONCATENATEX can concatenate multiple values, but the requirement is to show a fixed alternate phrase when multiple months are selected.

    References:

    • Create Expression-Based Titles and Subtitles
    • SELECTEDVALUE function

Membership includes 188 questions and explanations aligned to the PL-300 curriculum, including 10 case studies.

Other Microsoft certifications

Every one of these is included with the same membership as PL-300.

AB-900Microsoft

Microsoft 365 Copilot and Agent Administration Fundamentals

This exam is intended for candidates who are familiar with Microsoft 365, including core services, security, identity and access, data…

161 practice questionsView

AI-900Microsoft

Microsoft Azure AI Fundamentals

This exam measures knowledge of machine learning and AI concepts and related Microsoft Azure services. It is intended for candidates…

193 practice questionsView

AZ-900Microsoft

Microsoft Azure Fundamentals

This exam is intended for technology professionals who want to demonstrate foundational knowledge of cloud concepts and Microsoft Azure.…

170 practice questionsView

PL-300 exam FAQ