PL-300 Manage and secure Power BI Practice Question
A Power BI report uses a composite model combining Import and DirectQuery sources. When a user filters a visual, the report takes a long time to update. The admin wants to diagnose performance issues. Which tool should the admin use?
Answer choices
Why each option matters
Answer the question above first, then reveal the full breakdown to understand why each option is right or wrong.
Correct answer & explanation
✓
Performance Analyzer in Power BI Desktop.
The correct option is B, Performance Analyzer in Power BI Desktop, because it captures per-visual query timings and DAX query durations as the user interacts with the report, letting the admin pinpoint which visual or filter is slow in a composite model. It records each visual's rendering and query events, so the admin can see whether the delay comes from the Import or DirectQuery portion. DAX Studio (A) is useful for tuning individual DAX queries but does not profile the report's visual-by-visual interaction flow. The Power BI activity log (C) tracks usage and audit events, not query performance per visual, and the on-premises data gateway log (D) only covers gateway traffic for DirectQuery/refresh, not the full report rendering path.
Answer analysis
Option-by-option breakdown
For each option: why learners choose it and why it is or isn't the right answer here.
- ✗
DAX Studio.
Why it's wrong here
DAX Studio is a standalone tool for profiling and optimizing DAX queries, not for assessing Power BI report visual performance. Although it can capture the DAX queries a report sends to the model and show execution metrics, it does not associate those queries with individual visuals or include rendering time in the report canvas. In a composite model scenario, Performance Analyzer is the correct tool because it ties query timing directly to each visual and its interaction with import and DirectQuery sources.
- ✓
Performance Analyzer in Power BI Desktop.
Why this is correct
Performance Analyzer in Power BI Desktop is the intended diagnostic tool because it records a chronological breakdown of operations for each visual, including DAX query time, visual display time, and other report-level processes. This lets you identify whether the slowdown comes from the composite model's query engine when combining imported and DirectQuery tables or from rendering. The results can be exported to JSON for further investigation, making it the definitive answer for visual-level performance analysis.
- ✗
Power BI activity log.
Why it's wrong here
The Power BI activity log is an audit log of user actions, such as opening a report, sharing a dashboard, or exporting data. It does not contain query execution times, per-visual timings, or any data about how the composite model resolved a specific DAX query. Therefore, it is useful for monitoring usage and compliance, but it cannot help troubleshoot which visual is slow due to import/DirectQuery interaction.
- ✗
On-premises data gateway log.
Why it's wrong here
An on-premises data gateway log records the health and execution of connections through the gateway, including refresh history and data source query errors, but it does not profile visuals inside Power BI Desktop. Gateway logs can reveal latency introduced between the Power BI service and an on-premises source, yet they show no information about composite model query folding, relationship cardinality, or visual rendering in a report. Since the report may be using DirectQuery directly or a cloud source, gateway logs are only relevant in a narrow set of connectivity issues, not general visual performance analysis.
Go deeper
Related to this question
About these practice questions
One of 524 original PL-300 practice questions on Courseiva, each with a full explanation and wrong-answer analysis — not exam dumps or protected exam content. Learn why practice questions differ from exam dumps →
JA
Written by Johnson Ajibi, MSc IT Security
Senior Network & Security Engineer · founder of Courseiva
This PL-300 practice question is part of Courseiva's free Microsoft certification practice question bank. Courseiva provides original exam-style practice questions with explanations, topic-based practice, mock exams, readiness tracking, and study analytics to help learners prepare for the PL-300 exam.