Category: Microsoft Certification

Practice Questions: Configure Drill-Through Navigation (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Enhance reports for usability and storytelling
--> Configure Drill-Through Navigation


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

What is the primary purpose of drill-through navigation in Power BI?

A. To filter visuals within the same report page
B. To navigate to another report while preserving filters
C. To navigate to another report page while passing filter context
D. To display detailed data in a tooltip

Correct Answer: C

Explanation:
Drill-through allows users to navigate between pages in the same report while automatically passing filter context based on the selected data point.


Question 2

Where must a field be placed to enable drill-through functionality?

A. Visual-level filters
B. Page-level filters
C. Drill-through filters section
D. Report-level filters

Correct Answer: C

Explanation:
A page becomes a drill-through target only when one or more fields are added to the Drill-through filters section of the Filters pane.


Question 3

Which condition must be met for a visual to support drill-through to a target page?

A. The visual must be a table or matrix
B. The visual must contain the same field as the drill-through filter
C. The visual must be on the same page
D. The visual must contain all report filters

Correct Answer: B

Explanation:
A visual can initiate drill-through only if it contains at least one field that matches a field defined in the drill-through filters of the target page.


Question 4

A user right-clicks a data point but does not see the Drill-through option. What is the most likely cause?

A. Drill-through is disabled in Power BI Desktop
B. No drill-through fields were configured on the target page
C. The report has too many visuals
D. The page contains a Back button

Correct Answer: B

Explanation:
If no fields are added to the Drill-through filters on a page, Power BI will not expose that page as a drill-through option.


Question 5

What is the purpose of the Back button on a drill-through page?

A. Clears all filters
B. Returns users to the home page
C. Navigates back while preserving filter context
D. Refreshes visuals

Correct Answer: C

Explanation:
The Back button returns users to the source page and retains the original filter context, making it essential for usability and navigation.


Question 6

What happens when the Keep all filters option is enabled on a drill-through button?

A. Only drill-through filters are applied
B. Page-level filters are removed
C. All active filters and slicers are passed to the target page
D. Filters are ignored

Correct Answer: C

Explanation:
When enabled, Keep all filters ensures that all filter context, including slicers and page-level filters, is passed during drill-through.


Question 7

Which visual type does NOT support drill-through as a source visual?

A. Bar chart
B. Table
C. Matrix
D. Card

Correct Answer: D

Explanation:
Card visuals do not contain categorical context and therefore cannot initiate drill-through.


Question 8

Which statement best describes the relationship between drill-through and page navigation?

A. They serve the same purpose
B. Drill-through replaces bookmarks
C. Page navigation passes filter context automatically
D. Drill-through passes filter context; page navigation does not

Correct Answer: D

Explanation:
Drill-through uniquely passes filter context automatically, while page navigation simply moves between pages without context.


Question 9

Can drill-through be configured to pass multiple fields?

A. No, only one field is supported
B. Yes, but only from table visuals
C. Yes, by adding multiple fields to drill-through filters
D. Yes, but only with DAX

Correct Answer: C

Explanation:
Multiple fields can be added to the Drill-through filters section, allowing for compound filtering on the target page.


Question 10

Which scenario is the best use case for drill-through navigation?

A. Showing explanatory text
B. Switching between report themes
C. Moving from a summary KPI to transaction-level details
D. Applying conditional formatting

Correct Answer: C

Explanation:
Drill-through is designed to move from high-level summaries to detailed supporting data, making it ideal for analytical storytelling.


PL-300 Exam Tips for Drill-Through

  • Know where drill-through filters live
  • Understand filter context passing
  • Recognize supported and unsupported visuals
  • Expect scenario-based questions
  • Always think: “How does the user get more detail?”

Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Configure Export Settings (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Enhance reports for usability and storytelling
--> Configure Export Settings


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

A user exports data from a table visual and receives only aggregated values instead of individual rows. What is the most likely reason?

A. Row-Level Security is filtering the data
B. The visual is using a calculated column
C. Export of underlying data is disabled
D. The dataset is using DirectQuery

Correct Answer: C

Explanation:
When underlying data export is disabled, Power BI allows only summarized data to be exported. This is commonly used to prevent access to row-level data.


Question 2

Which export option preserves visual formatting but removes interactivity?

A. Export data to Excel
B. Export summarized data
C. Export as PDF
D. Analyze in Excel

Correct Answer: C

Explanation:
Exporting to PDF preserves layout and formatting but results in a static, non-interactive file.


Question 3

A report author disables export options for a visual, but users can still export data in the Power BI Service. What is the most likely cause?

A. Dataset permissions override visual settings
B. Row-Level Security is disabled
C. Visual interactions are enabled
D. The report is using Import mode

Correct Answer: A

Explanation:
Dataset and tenant-level settings can override visual-level restrictions, allowing exports even if a visual is configured to restrict them.


Question 4

Which export behavior always respects Row-Level Security (RLS)?

A. Export summarized data
B. Export underlying data
C. Export to Excel
D. All export methods

Correct Answer: D

Explanation:
All export methods in Power BI respect RLS, ensuring users only export data they are authorized to see.


Question 5

An organization wants to prevent users from exporting row-level data across all reports. Where should this be configured?

A. Visual formatting pane
B. Report settings in Power BI Desktop
C. Dataset settings in Power BI Service
D. Power BI Admin portal

Correct Answer: D

Explanation:
The Power BI Admin portal allows administrators to enforce export restrictions tenant-wide, overriding report and dataset settings.


Question 6

Which export option allows users to include current slicer and filter selections?

A. Export summarized data
B. Export report to PDF
C. Export underlying data
D. Copy visual as image

Correct Answer: B

Explanation:
When exporting a report to PDF, users can choose to export with current values, which includes applied filters and slicers.


Question 7

A user wants to export data for further analysis while keeping the original Power BI dataset connected. Which option should they use?

A. Export underlying data
B. Export summarized data
C. Analyze in Excel
D. Export to PowerPoint

Correct Answer: C

Explanation:
Analyze in Excel maintains a live connection to the Power BI dataset, enabling dynamic analysis without extracting the data.


Question 8

What happens if underlying data export is disabled but summarized data export is enabled?

A. Users cannot export data
B. Users can export aggregated values only
C. Users can export only visuals
D. Users can export row-level data

Correct Answer: B

Explanation:
With underlying data disabled, Power BI allows exports of aggregated values only, matching what is displayed in the visual.


Question 9

Which export format is best suited for executive summaries and board-level reporting?

A. Excel (.xlsx)
B. CSV
C. PDF
D. Analyze in Excel

Correct Answer: C

Explanation:
PDF exports are ideal for executive reporting because they preserve formatting and are easy to distribute and consume.


Question 10

A report uses sensitivity labels that restrict data sharing. What impact do these labels have on exports?

A. They remove all export options
B. They allow exports but remove filters
C. They may restrict or block exports based on policy
D. They only affect sharing, not exporting

Correct Answer: C

Explanation:
Sensitivity labels can enforce data protection rules, including restricting or disabling export options depending on organizational policies.


Final Exam Tip

For PL-300, always think in this order when troubleshooting exports:

Tenant → Dataset → Report → Visual

The most restrictive setting wins, and security is never bypassed.


Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Design Reports for Mobile Devices (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Enhance reports for usability and storytelling
--> Design Reports for Mobile Devices


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

You publish a Power BI report that was designed only using the standard report canvas. A user views the report in the Power BI mobile app. What happens?

A. The report cannot be opened
B. The report automatically switches to a paginated view
C. The desktop layout is shown, scaled to fit the screen
D. The mobile layout is generated automatically

Correct Answer: C

Explanation:
If no mobile layout is defined, Power BI displays the desktop layout scaled to fit the mobile screen, which often leads to poor usability.


Question 2

Which Power BI feature allows you to create a phone-optimized layout for a report page?

A. Bookmarks
B. Focus mode
C. Mobile layout view
D. Selection pane

Correct Answer: C

Explanation:
The Mobile layout view in Power BI Desktop lets you design a separate layout specifically optimized for mobile devices.


Question 3

Which of the following is true about visuals in a mobile layout?

A. All desktop visuals automatically appear
B. Only selected visuals appear
C. Visuals appear but cannot be resized
D. Mobile layouts only support cards and charts

Correct Answer: B

Explanation:
Only visuals that you explicitly add to the mobile layout will appear in the Power BI mobile app.


Question 4

What is the recommended layout pattern for mobile report pages?

A. Multi-column grids
B. Side-by-side visuals
C. Freeform overlapping visuals
D. Single-column vertical scrolling

Correct Answer: D

Explanation:
Mobile reports should use single-column, vertically stacked visuals to support natural scrolling and readability.


Question 5

Which visual type is generally least suitable for mobile report layouts?

A. KPI card
B. Line chart
C. Large matrix with many columns
D. Bar chart

Correct Answer: C

Explanation:
Large matrices with many columns are difficult to read and interact with on small mobile screens.


Question 6

A report consumer needs to interact with slicers on a mobile device. What is the best design approach?

A. Add as many slicers as possible
B. Use dropdown slicers and limit their number
C. Place slicers at the bottom of the page
D. Disable slicers for mobile layouts

Correct Answer: B

Explanation:
Dropdown slicers save space and improve usability on small screens. Limiting the number of slicers is a best practice.


Question 7

Which of the following actions can help improve performance of mobile reports?

A. Adding more visuals
B. Increasing visual interactivity
C. Reducing the number of visuals per page
D. Using larger images

Correct Answer: C

Explanation:
Mobile devices have limited resources. Reducing the number of visuals improves performance and load times.


Question 8

How does Power BI handle drill-through functionality on mobile devices?

A. Drill-through is not supported
B. Drill-through works only in landscape mode
C. Drill-through works but must be clearly designed
D. Drill-through only works on paginated reports

Correct Answer: C

Explanation:
Drill-through works on mobile, but users must be able to clearly identify how to access it, often through large touch-friendly visuals.


Question 9

When should you create a mobile layout instead of relying on the desktop layout?

A. Only when using paginated reports
B. When users will primarily view reports on phones
C. Only when using DirectQuery
D. When exporting to PowerPoint

Correct Answer: B

Explanation:
If report consumption is primarily on mobile devices, creating a dedicated mobile layout is strongly recommended.


Question 10

Which of the following statements about mobile layouts is correct?

A. Mobile layouts replace desktop layouts
B. Mobile layouts must be created before publishing
C. Each report page can have its own mobile layout
D. Mobile layouts only work in Power BI Desktop

Correct Answer: C

Explanation:
Each report page can have its own mobile-specific layout, independent of other pages.


Exam Readiness Tip

For PL-300 questions mentioning:

  • Phones
  • Power BI mobile app
  • Executives on the go
  • Small screens

👉 Think mobile layout, simplified visuals, and touch-friendly design.


Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Enable Personalized Visuals in a Report (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Enhance reports for usability and storytelling
--> Enable Personalized Visuals in a Report


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

What is the primary purpose of enabling personalized visuals in a Power BI report?

A. To allow users to edit the data model
B. To let users customize visuals without changing the original report
C. To allow multiple users to edit the same report simultaneously
D. To improve dataset refresh performance

Correct Answer: B

Explanation:
Personalized visuals allow users to customize visuals for their own view while leaving the original report unchanged.


Question 2

Where do you enable personalized visuals for a report?

A. Dataset settings
B. Visual formatting pane
C. Report settings in Power BI Service
D. Workspace settings

Correct Answer: C

Explanation:
Personalized visuals are enabled at the report level through File → Settings in the Power BI Service.


Question 3

Which of the following changes can a user make when personalized visuals are enabled?

A. Create new DAX measures
B. Modify table relationships
C. Change the visual type
D. Edit the dataset schema

Correct Answer: C

Explanation:
Users can change the visual type, fields, filters, and sorting, but cannot modify the data model or DAX.


Question 4

What happens when a user saves their personalized visual?

A. The report is updated for all users
B. The dataset is modified
C. The change is saved only for that user
D. A new version of the report is created

Correct Answer: C

Explanation:
Personalized changes are user-specific and do not affect other users or the original report.


Question 5

Which permission is required for a user to personalize visuals?

A. Admin access
B. Dataset owner
C. Edit permissions on the report
D. No edit permissions required

Correct Answer: D

Explanation:
Users do not need edit permissions to personalize visuals—only the report author must enable the feature.


Question 6

A user wants to undo their personalized changes and return to the default report view. What should they do?

A. Republish the report
B. Refresh the dataset
C. Select “Reset to default”
D. Clear browser cache

Correct Answer: C

Explanation:
The Reset to default option restores the original author-designed visuals for that user.


Question 7

Which scenario best supports enabling personalized visuals?

A. Regulatory financial reporting
B. Pixel-perfect invoice reports
C. Self-service analytical dashboards
D. Static executive board reports

Correct Answer: C

Explanation:
Personalized visuals are ideal for self-service analytics, where users need flexibility without modifying reports.


Question 8

Which of the following actions is NOT supported by personalized visuals?

A. Changing aggregations
B. Adding fields to a visual
C. Editing report-level filters
D. Modifying relationships

Correct Answer: D

Explanation:
Personalized visuals cannot alter data model relationships, ensuring governance and consistency.


Question 9

If personalized visuals are disabled, what option will users no longer see?

A. Focus mode
B. Drill-through
C. Export data
D. Personalize this visual

Correct Answer: D

Explanation:
Disabling personalized visuals removes the “Personalize this visual” option from the visual menu.


Question 10

Why might an organization choose to disable personalized visuals?

A. To improve visual rendering speed
B. To reduce report file size
C. To maintain strict visual consistency
D. To allow dataset editing

Correct Answer: C

Explanation:
In highly curated or compliance-driven reports, organizations may disable personalization to maintain consistent visual presentation.


Exam Tip

If a PL-300 question mentions:

  • Users wanting to adjust visuals
  • Avoiding edit permissions
  • User-specific customizations

👉 Enable personalized visuals is often the correct solution.


Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Design and Configure Power BI Reports for Accessibility (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Enhance reports for usability and storytelling
--> Design and Configure Power BI Reports for Accessibility


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

What is the primary purpose of adding alt text to visuals in Power BI?

A. Improve visual rendering performance
B. Describe visuals for screen reader users
C. Enable drill-through navigation
D. Improve data refresh speed

Correct Answer: B

Explanation:
Alt text provides a text description of a visual so screen readers can communicate the visual’s meaning to users with visual impairments.


Question 2

Where do you configure alt text for a visual in Power BI Desktop?

A. Fields pane
B. Selection pane
C. Format pane → General
D. View → Accessibility

Correct Answer: C

Explanation:
Alt text is configured in the Format pane, under the General section of the visual.


Question 3

Why is configuring tab order important for accessibility?

A. It improves dataset performance
B. It determines how visuals load
C. It controls keyboard navigation sequence
D. It enables mobile layouts

Correct Answer: C

Explanation:
Tab order defines the sequence in which users navigate visuals using a keyboard or screen reader.


Question 4

Which Power BI feature allows you to set the tab order of visuals?

A. Bookmarks
B. Selection pane
C. Visual interactions
D. Drill-through settings

Correct Answer: B

Explanation:
The Selection pane includes Tab order settings that control keyboard navigation order.


Question 5

Which design choice improves accessibility for users with color vision deficiencies?

A. Using red and green to show performance
B. Relying only on color gradients
C. Adding labels or icons in addition to color
D. Removing legends

Correct Answer: C

Explanation:
Information should not rely on color alone. Labels or icons ensure meaning is conveyed to all users.


Question 6

Which visual characteristic may negatively impact accessibility?

A. Clear visual titles
B. High-contrast color schemes
C. Overlapping visuals
D. Descriptive axis labels

Correct Answer: C

Explanation:
Overlapping visuals create confusion for screen readers and keyboard navigation, reducing accessibility.


Question 7

Which action helps ensure Power BI reports are usable with screen readers?

A. Disabling tooltips
B. Providing meaningful alt text
C. Using only custom visuals
D. Increasing dataset size

Correct Answer: B

Explanation:
Screen readers rely on alt text and logical navigation to communicate report content.


Question 8

What is the recommended approach when using color to convey information?

A. Use as many colors as possible
B. Use color only for decoration
C. Combine color with text or shape indicators
D. Avoid color entirely

Correct Answer: C

Explanation:
Combining color with text or shapes ensures information is accessible to users with color vision impairments.


Question 9

Which scenario most clearly requires accessibility-focused report design?

A. Personal analysis reports
B. Internal development dashboards
C. Public-facing or regulated reports
D. Temporary testing reports

Correct Answer: C

Explanation:
Public-facing and regulated reports often require accessibility compliance to meet legal and organizational standards.


Question 10

Which of the following is a best practice for accessible Power BI report design?

A. Use dense matrices with small fonts
B. Hide key information in tooltips only
C. Use descriptive titles and readable fonts
D. Overuse conditional formatting

Correct Answer: C

Explanation:
Clear titles, readable fonts, and logical layouts improve accessibility and usability for all users.


Exam Tip

If a PL-300 question references:

  • Screen readers
  • Keyboard navigation
  • Visual impairments
  • Accessibility standards

👉 Think alt text, tab order, color contrast, and clear labeling.


Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Configure automatic page refresh (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Enhance reports for usability and storytelling
--> Configure automatic page refresh


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

You need a Power BI report page to automatically update visuals every 30 seconds without user interaction. Which requirement must be met?

A. The dataset must use Import mode
B. The report must use DirectQuery or a Live connection
C. The dataset must be scheduled for refresh every 30 seconds
D. The report must be published to Excel

Correct Answer: B

Explanation:
Automatic page refresh only works with DirectQuery or Live connections. Import mode datasets cannot support page-level automatic refresh.


Question 2

Where do you enable automatic page refresh in Power BI Desktop?

A. Dataset settings
B. Model view
C. Page formatting pane
D. Query Editor

Correct Answer: C

Explanation:
Automatic page refresh is configured at the page level using the Format page pane in Power BI Desktop.


Question 3

Which refresh option only updates visuals when underlying data changes?

A. Dataset refresh
B. Fixed interval refresh
C. Scheduled refresh
D. Change detection refresh

Correct Answer: D

Explanation:
Change detection refresh uses a DAX measure to detect data changes and refresh visuals only when necessary.


Question 4

A report uses Import mode and requires visuals to refresh automatically every minute. What should you do?

A. Enable automatic page refresh
B. Use change detection refresh
C. Switch the dataset to DirectQuery
D. Increase scheduled refresh frequency

Correct Answer: C

Explanation:
Automatic page refresh is not supported in Import mode. To enable it, the dataset must be converted to DirectQuery.


Question 5

Which DAX component is required to configure change detection refresh?

A. Calculated column
B. Aggregation table
C. Measure
D. Hierarchy

Correct Answer: C

Explanation:
Change detection refresh relies on a DAX measure whose value changes when the underlying data changes.


Question 6

What is the primary benefit of using change detection instead of a fixed refresh interval?

A. Faster dataset refresh
B. Reduced load on the data source
C. Works with Import mode
D. Eliminates the need for DirectQuery

Correct Answer: B

Explanation:
Change detection reduces unnecessary queries by refreshing visuals only when data changes, improving performance.


Question 7

Which scenario is the best candidate for automatic page refresh?

A. Monthly financial reporting
B. Historical trend analysis
C. Executive scorecards reviewed quarterly
D. Real-time call center monitoring dashboard

Correct Answer: D

Explanation:
Automatic page refresh is designed for near real-time operational dashboards, such as call center or IoT monitoring.


Question 8

Which factor limits how frequently automatic page refresh can run?

A. Visual type
B. Number of report pages
C. Power BI capacity and licensing
D. Dataset size

Correct Answer: C

Explanation:
Refresh frequency is governed by Power BI capacity, licensing (Pro vs Premium), and system performance limits.


Question 9

What happens if you configure a very short refresh interval on a high-traffic report?

A. Power BI automatically switches to Import mode
B. Dataset refresh is triggered instead
C. Data source and performance may be negatively impacted
D. The report becomes read-only

Correct Answer: C

Explanation:
Short refresh intervals can overload the data source and degrade report performance, especially in shared environments.


Question 10

Which statement about automatic page refresh is true?

A. It refreshes the entire dataset
B. It only works in Power BI Desktop
C. It refreshes visuals at the page level
D. It replaces scheduled dataset refresh

Correct Answer: C

Explanation:
Automatic page refresh operates at the page level, refreshing visuals without reloading the entire dataset.


Exam Tip Summary

  • Automatic page refresh = page-level, not dataset-level
  • Requires DirectQuery or Live connection
  • Supports fixed interval and change detection
  • Best for real-time operational dashboards
  • Overuse can impact performance

Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Use the Analyze Feature in Power BI (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Identify patterns and trends
--> Use the Analyze Feature in Power BI


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

A business user wants to understand why total sales increased from one month to the next without writing DAX. Which Analyze feature should they use?

A. Key influencers
B. Decomposition tree
C. Explain the increase
D. Quick insights

Correct Answer: C

Explanation:
Explain the increase automatically analyzes contributing factors behind a change between two data points, such as month-over-month sales growth.


Question 2

Which requirement must be met to use anomaly detection in Power BI?

A. The data must include calculated columns
B. The visual must use a time-based axis
C. The dataset must be in Import mode
D. The report must be published to the service

Correct Answer: B

Explanation:
Anomaly detection requires a continuous time-based axis (such as date or time) to identify unexpected spikes or dips.


Question 3

A report author wants to identify which customer attributes most strongly influence high revenue. Which visual should they use?

A. Decomposition tree
B. Analyze insights
C. Key influencers
D. Explain the decrease

Correct Answer: C

Explanation:
The Key influencers visual uses machine learning to determine which factors most strongly influence a selected metric.


Question 4

Which Analyze feature allows users to manually or automatically split a measure across multiple dimensions?

A. Explain the increase
B. Decomposition tree
C. Analyze insights
D. Quick insights

Correct Answer: B

Explanation:
The Decomposition tree allows step-by-step breakdown of a measure using either manual selections or AI-driven splits.


Question 5

A user right-clicks a bar in a column chart and selects Analyze → Explain the decrease. What does Power BI generate?

A. A new calculated measure
B. A static tooltip
C. AI-generated visuals explaining contributing factors
D. A drill-through page

Correct Answer: C

Explanation:
Power BI generates read-only AI-generated visuals that explain what contributed to the decrease.


Question 6

Which statement about Analyze insights is TRUE?

A. It modifies the data model
B. It only works on tables
C. It provides automatic pattern detection within a visual
D. It requires DAX measures

Correct Answer: C

Explanation:
Analyze insights automatically detect patterns, trends, outliers, and correlations within supported visuals.


Question 7

A dataset is published to the Power BI Service. A user wants Power BI to automatically scan the entire dataset for trends and outliers. Which feature should they use?

A. Analyze insights
B. Key influencers
C. Decomposition tree
D. Quick insights

Correct Answer: D

Explanation:
Quick insights run in the Power BI Service and analyze the entire dataset, not just individual visuals.


Question 8

Which Analyze feature is best suited for explaining why a KPI changed between two specific points in time?

A. Key influencers
B. Decomposition tree
C. Explain the increase/decrease
D. Analyze insights

Correct Answer: C

Explanation:
Explain the increase/decrease is designed specifically to analyze changes between two values.


Question 9

Why might Analyze features produce poor or misleading results?

A. The report uses DirectQuery
B. Relationships and data types are poorly designed
C. The dataset contains too many measures
D. Visual interactions are disabled

Correct Answer: B

Explanation:
Analyze features rely heavily on clean data, correct relationships, and appropriate data types to generate accurate insights.


Question 10

Which statement best describes the role of Analyze features in Power BI?

A. They replace the need for DAX
B. They permanently alter report visuals
C. They assist with exploratory analysis and insight discovery
D. They are required for all Power BI reports

Correct Answer: C

Explanation:
Analyze features are designed for exploratory analysis and pattern discovery, not as replacements for modeling or DAX.


PL-300 Exam Tip

Expect scenario-based questions that test:

  • Which Analyze feature to use
  • Feature limitations and requirements
  • Differences between similar tools (Key influencers vs Decomposition tree, Analyze insights vs Quick insights)

Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Use Reference Lines, Error Bars, and Forecasting (PL-300 Exam Guide)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Visualize and analyze the data (25–30%)
--> Identify patterns and trends
--> Use Reference Lines, Error Bars, and Forecasting


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

A sales manager wants to see how monthly sales compare against a fixed revenue target on a line chart. What feature should you use?

A. Forecast
B. Error bars
C. Constant reference line
D. Decomposition Tree

Correct Answer: C

Explanation:
A constant reference line allows you to display a fixed benchmark, such as a sales target, across a visual.


Question 2

Which pane in Power BI Desktop is used to add reference lines, error bars, and forecasting to a visual?

A. Fields pane
B. Visualizations pane
C. Filters pane
D. Analytics pane

Correct Answer: D

Explanation:
All three features—reference lines, error bars, and forecasting—are configured in the Analytics pane.


Question 3

You want to show how much variation exists around average daily production values. Which feature is most appropriate?

A. Forecast
B. Error bars
C. Average line
D. Percentile line

Correct Answer: B

Explanation:
Error bars visualize variability or uncertainty, making them ideal for showing ranges around a value.


Question 4

Which type of reference line dynamically adjusts based on the data displayed in the visual?

A. Constant line
B. Target line
C. Average line
D. Fixed percentile

Correct Answer: C

Explanation:
An average line recalculates automatically based on the values currently shown in the visual.


Question 5

What is a requirement for using forecasting in Power BI?

A. The dataset must use DirectQuery
B. The visual must be a line chart with a continuous date axis
C. A calculated column must exist
D. The data must be categorical

Correct Answer: B

Explanation:
Forecasting requires a line chart and a continuous time-based axis, such as a date or datetime field.


Question 6

Which statement about forecasting in Power BI is true?

A. Forecasting creates new measures
B. Forecasting permanently modifies the dataset
C. Forecasting uses historical trends to predict future values
D. Forecasting works on all visual types

Correct Answer: C

Explanation:
Power BI forecasting applies time-series analysis to historical data to project future values.


Question 7

A report needs to show whether performance values fall above or below the median. Which reference line should you use?

A. Constant line
B. Percentile line
C. Median line
D. Forecast line

Correct Answer: C

Explanation:
A median line highlights the midpoint of the data and helps compare values above or below it.


Question 8

Which scenario best justifies the use of error bars?

A. Comparing values to a fixed target
B. Explaining why a metric changed
C. Showing uncertainty or confidence ranges
D. Predicting future outcomes

Correct Answer: C

Explanation:
Error bars are used to represent uncertainty, variability, or confidence intervals, not targets or predictions.


Question 9

Which limitation applies to Power BI forecasting?

A. It requires manual DAX calculations
B. It does not support confidence intervals
C. It cannot account for external factors not present in historical data
D. It only works in Power BI Service

Correct Answer: C

Explanation:
Forecasting relies entirely on historical patterns, so it cannot consider external events unless they are reflected in the data.


Question 10

Which combination of features would best support analyzing trends, performance benchmarks, and uncertainty in a single visual?

A. Forecasting only
B. Error bars only
C. Reference line and forecast
D. Reference lines, error bars, and forecasting

Correct Answer: D

Explanation:
Using all three together allows you to show benchmarks (reference lines), variability (error bars), and future projections (forecasting).


PL-300 Exam Tips

  • Reference lines → benchmarks, averages, targets
  • Error bars → variability and uncertainty
  • Forecasting → time-series predictions
  • All are configured in the Analytics pane
  • None of these features modify the underlying data

Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Create and configure a workspace (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
--> Create and manage workspaces and assets
--> Create and configure a workspace


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


Question 1

You want to allow a user to publish reports and update semantic models, but not manage users or workspace settings. Which workspace role should you assign?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: C. Member

Explanation:
Members can create, edit, publish, and update content but cannot manage workspace settings or users. Contributors can create content but have more limitations than Members. Admins have full control.


Question 2

Which workspace role provides read-only access to reports and dashboards?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: A. Viewer

Explanation:
Viewers can only consume content. They cannot edit, publish, or share assets. This role is commonly used for business users.


Question 3

You need to use Copilot, deployment pipelines, and large semantic models in a workspace. What must you configure?

A. Assign Admin role to all users
B. Enable dataset endorsements
C. Move the workspace to Premium capacity
D. Publish a Power BI App

Correct Answer: C. Move the workspace to Premium capacity

Explanation:
Advanced features such as Copilot, deployment pipelines, and large semantic models require Premium (or Fabric) capacity.


Question 4

Which object is NOT stored inside a Power BI workspace?

A. Report
B. Dashboard
C. Semantic model
D. Power BI App

Correct Answer: D. Power BI App

Explanation:
Apps are published from workspaces but are not stored as workspace assets themselves.


Question 5

Who can add or remove users from a workspace?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: D. Admin

Explanation:
Only workspace Admins can manage access and change workspace-level settings.


Question 6

A team wants to collaborate on report development but ensure that end users cannot modify reports. What is the BEST approach?

A. Give all users Member access
B. Share individual reports
C. Publish an app from the workspace
D. Use row-level security

Correct Answer: C. Publish an app from the workspace

Explanation:
Publishing an app provides a read-only, curated experience for consumers while allowing developers to work in the workspace.


Question 7

Which workspace role can create and modify content but cannot publish apps or manage access?

A. Viewer
B. Contributor
C. Member
D. Admin

Correct Answer: B. Contributor

Explanation:
Contributors can build and modify content but cannot manage users or publish apps.


Question 8

You want to ensure support requests and ownership questions are directed correctly. Which workspace setting helps with this?

A. Assigning Admin role
B. Workspace description
C. Contact list
D. App permissions

Correct Answer: C. Contact list

Explanation:
The contact list identifies workspace owners or support contacts and is a recommended best practice.


Question 9

Which scenario BEST justifies creating multiple workspaces instead of a single one?

A. Different teams own different datasets
B. Users want different slicer behavior
C. Reports use different visuals
D. Dashboards need bookmarks

Correct Answer: A. Different teams own different datasets

Explanation:
Workspaces should align with ownership, security boundaries, and business domains, not visual design preferences.


Question 10

Which statement about Power BI workspaces is TRUE?

A. Workspaces can only contain reports
B. Workspace roles apply only to dashboards
C. Apps must be published from a workspace
D. Viewers can publish new content

Correct Answer: C. Apps must be published from a workspace

Explanation:
All Power BI Apps are published from workspaces. Viewers cannot publish content, and workspaces contain multiple asset types.


Quick Exam Tips

  • Admins manage access and settings
  • Members publish and collaborate
  • Contributors build but don’t manage
  • Viewers consume only
  • Premium capacity unlocks advanced features
  • Apps = curated, read-only distribution

Go back to the PL-300 Exam Prep Hub main page

Practice Questions: Configure a semantic model scheduled refresh (PL-300 Exam Prep)

This post is a part of the PL-300: Microsoft Power BI Data Analyst Exam Prep Hub; and this topic falls under these sections:
Manage and secure Power BI (15–20%)
--> Create and manage workspaces and assets
--> Configure a semantic model scheduled refresh


Below are 10 practice questions (with answers and explanations) for this topic of the exam.
There are also 2 practice tests for the PL-300 exam with 60 questions each (with answers) available on the hub.

Practice Questions


1. Which semantic model supports scheduled refresh in the Power BI service?

A. A DirectQuery model connected to Azure SQL Database
B. A live connection to Azure Analysis Services
C. An Import mode model connected to a CSV file
D. A DirectQuery model connected to an on-premises SQL Server

Correct Answer: C

Explanation:
Scheduled refresh is supported only for semantic models that include Import mode tables. DirectQuery and live connection models do not store data in Power BI and therefore do not support scheduled refresh.


2. Where do you configure scheduled refresh for a semantic model?

A. In Power BI Desktop under Data Source Settings
B. In the workspace settings in the Power BI service
C. In the semantic model settings in the Power BI service
D. In Microsoft Fabric capacity settings

Correct Answer: C

Explanation:
Scheduled refresh is configured in the Power BI service by opening the semantic model settings, not in Power BI Desktop.


3. A semantic model uses Import mode and connects to an on-premises SQL Server. What is required to enable scheduled refresh?

A. Azure AD authentication
B. A dataflow
C. An on-premises data gateway
D. A Premium workspace

Correct Answer: C

Explanation:
An on-premises data gateway is required whenever Power BI needs to access data sources located inside a private network.


4. What is the maximum number of scheduled refreshes per day for a dataset in a shared capacity workspace?

A. 4
B. 8
C. 24
D. 48

Correct Answer: B

Explanation:
In shared capacity, Power BI allows up to 8 scheduled refreshes per day per semantic model.


5. Which scenario does NOT require a scheduled refresh?

A. Import mode model using Excel files
B. Composite model with imported tables
C. DirectQuery model connected to Azure SQL Database
D. Import mode model using SharePoint Online

Correct Answer: C

Explanation:
DirectQuery models query the source data in real time and therefore do not use scheduled refresh.


6. A scheduled refresh is failing because credentials have expired. Where should the credentials be updated?

A. Power BI Desktop
B. Gateway configuration tool
C. Semantic model settings in the Power BI service
D. Workspace access settings

Correct Answer: C

Explanation:
Data source credentials are managed within the semantic model settings in the Power BI service.


7. What happens if a dataset contains both Import and DirectQuery tables?

A. Scheduled refresh is disabled
B. Only Import tables are refreshed
C. Only DirectQuery tables are refreshed
D. The dataset must be republished

Correct Answer: B

Explanation:
In composite models, scheduled refresh refreshes only Import mode tables. DirectQuery tables always query data live.


8. Which feature reduces refresh duration by refreshing only new or changed data?

A. Query folding
B. Dataflows
C. Incremental refresh
D. DirectQuery

Correct Answer: C

Explanation:
Incremental refresh minimizes refresh time by refreshing only data partitions that have changed, but it still relies on scheduled refresh to execute.


9. What is a common cause of scheduled refresh failure?

A. Too many visuals on a report page
B. Dataset size exceeding 1 GB
C. Gateway being offline
D. Using DAX measures

Correct Answer: C

Explanation:
If the gateway is offline or misconfigured, Power BI cannot access on-premises data sources, causing scheduled refresh to fail.


10. A dataset in a Premium workspace needs to refresh every 30 minutes. Is this supported?

A. Yes, Premium supports up to 48 refreshes per day
B. Yes, all datasets support 30-minute intervals
C. No, refresh frequency is fixed at 8 per day
D. No, scheduled refresh cannot be automated

Correct Answer: A

Explanation:
Premium capacity supports up to 48 refreshes per day, allowing more frequent refresh intervals than shared capacity.


✔️ Exam Tip Summary

  • Import mode → scheduled refresh
  • DirectQuery → no scheduled refresh
  • On-premises source → gateway required
  • Refresh settings → Power BI service
  • Premium capacity → higher refresh limits

Go back to the PL-300 Exam Prep Hub main page