How many Troubleshooting Scenario Questions questions are on this page?

This page has 5 Troubleshooting Scenario Questions scenario questions for the PL-300 exam, each with detailed explanations and wrong-answer analysis.

How should I approach PL-300 scenario questions?

Read the full scenario before looking at the answer options. Identify the constraint or requirement in the scenario, then eliminate options that are generally true but wrong for this specific case. Scenario questions reward careful reading over pattern matching.

← Back to Microsoft Power BI Data Analyst PL-300 questions

Scenario-based practice

Troubleshooting Scenario Questions

Practise Microsoft Power BI Data Analyst PL-300 practice questions — original exam-style scenarios covering every exam domain, with detailed explanations, wrong-answer analysis, and common exam traps.

Start full practice test Read exam guide

scenario questions

PL-300

exam code

Microsoft

vendor

Scenario guide

How to approach troubleshooting scenario questions

These questions describe a network symptom and ask you to identify the root cause or the correct fix. They appear across all certification exams and reward systematic thinking over memorisation. The best candidates follow a consistent troubleshooting framework even under time pressure.

Quick answer

Troubleshooting Scenario Questions questions test whether you can apply the concept in context, not just recognise a definition.

How the topic appears in realistic exam-style scenarios.

Which detail in the question changes the correct answer.

How to eliminate plausible but wrong options.

How to connect the question back to the wider exam objective.

Practice scenarios

Question 1mediummultiple choice

Full question →

You are troubleshooting connectivity to a Power BI Premium dataset via the XMLA endpoint. A user reports that they cannot connect using SQL Server Management Studio (SSMS) but can view reports in the Power BI service. The user's email is user3@contoso.com. What is the most likely cause?

Exhibit

Refer to the exhibit.

Power BI XMLA endpoint configuration:
{
  "allowedUsers": [
    "user1@contoso.com",
    "user2@contoso.com"
  ],
  "allowAzureAnalysisServicesConnections": true,
  "blockExternalConnections": false
}

A
External connections are blocked by the configuration.
Why wrong: blockExternalConnections is false.
B
The user does not have permission to view reports.
Why wrong: They can view reports.
C
The user is not in the allowedUsers list for the XMLA endpoint.
Only user1 and user2 are allowed.
D
The XMLA endpoint is disabled.
Why wrong: The configuration shows it is enabled.

Full breakdown with real-world context →

Question 2mediummulti select

Full question →

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. Which three steps should you take to troubleshoot?

A
Disable hardware acceleration in Power BI Desktop
Why wrong: Hardware acceleration is not specific to custom visuals.
B
Check if the visual version is compatible with your Power BI Desktop version
Incompatibility can cause rendering issues.
C
Update the visual to the latest version from AppSource
Updates may fix bugs.
D
Clear the browser cache
Why wrong: Clearing cache is for browser-based reports, not for Desktop.
E
Verify that the visual uses the correct data fields
Incorrect field mapping can cause blank or error visuals.

Full breakdown with real-world context →

Question 3hardmultiple choice

Full question →

You are troubleshooting a Power BI DirectQuery model that connects to a SQL Server database. A slicer on 'Region' is slow to respond. The region column has 50 distinct values. What is the best optimization?

A
Create an index on the Region column in the source database
Indexing the column used in slicers improves query performance in DirectQuery.
B
Increase the cache size in Power BI Desktop
Why wrong: Cache settings affect Import mode, not DirectQuery.
C
Switch the model to Import mode
Why wrong: Import mode is not always an option due to data size or real-time requirements.
D
Reduce the number of distinct values in Region
Why wrong: Reducing distinct values is not a best practice and may lose detail.

Full breakdown with real-world context →

Question 4hardmultiple choice

Full question →

You are troubleshooting a Power BI report that uses a measure with the following formula: Profit Margin = DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue])). The measure returns blank for rows where revenue is zero. You want to display 0% instead of blank. What should you do?

A
Use COALESCE([Profit Margin], 0).
Why wrong: COALESCE would replace blank with 0, but the measure still returns blank initially.
B
Add a third argument to DIVIDE: DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue]), 0).
Correct. The third argument returns 0 when denominator is 0.
C
Use IFERROR( [Profit Margin], 0).
Why wrong: IFERROR does not catch blank from DIVIDE.
D
Wrap the measure with IF(ISBLANK([Profit Margin]), 0, [Profit Margin]).
Why wrong: The measure itself returns blank, so ISBLANK would be true but the measure still blank.

Full breakdown with real-world context →

Question 5mediummultiple choice

Full question →

You have a Power BI report that uses a date hierarchy (Year, Quarter, Month) on the axis of a line chart. Users want to drill down from year to quarter to month. However, the drill-down feature is not working. What is the most likely cause?

A
The date field is placed in the Axis field well without creating a hierarchy.
Drill-down requires explicit hierarchy in the field well.
B
The line chart does not support drill-down functionality.
Why wrong: Line charts support drill-down with hierarchies.
C
The date table is not marked as a date table in the model.
Why wrong: Marking as date table is not required for drill-down.
D
Cross-filtering from another visual is interfering.
Why wrong: Cross-filtering does not disable drill-down.

Full breakdown with real-world context →

These PL-300 practice questions are part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style PL-300 questions with detailed explanations, topic-based practice, mock exams, readiness tracking, and study analytics.

Troubleshooting Scenario Questions

How to approach troubleshooting scenario questions

Quick answer

Related PL-300 topic practice pages

Prepare the data practice questions

Deploy and maintain assets practice questions

Model the data practice questions

Visualize and analyze the data practice questions

Manage and secure Power BI practice questions

PL-300 fundamentals practice questions

PL-300 scenario practice questions

PL-300 troubleshooting practice questions

Practice scenarios

You are troubleshooting connectivity to a Power BI Premium dataset via the XMLA endpoint. A user reports that they cannot connect using SQL Server Management Studio (SSMS) but can view reports in the Power BI service. The user's email is user3@contoso.com. What is the most likely cause?

Exhibit

You have a Power BI report that uses a custom visual from AppSource. The visual is not rendering correctly. Which three steps should you take to troubleshoot?

You are troubleshooting a Power BI DirectQuery model that connects to a SQL Server database. A slicer on 'Region' is slow to respond. The region column has 50 distinct values. What is the best optimization?

You are troubleshooting a Power BI report that uses a measure with the following formula: Profit Margin = DIVIDE(SUM(Transactions[Profit]), SUM(Transactions[Revenue])). The measure returns blank for rows where revenue is zero. You want to display 0% instead of blank. What should you do?

You have a Power BI report that uses a date hierarchy (Year, Quarter, Month) on the axis of a line chart. Users want to drill down from year to quarter to month. However, the drill-down feature is not working. What is the most likely cause?