nerdexam
Microsoft

PL-300 · Question #137

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that…

The correct answer is B. Remove unused columns from tables in the data model. Removing unused columns from the data model directly reduces the overall model size and the amount of data processed, significantly improving report load and interaction performance.

Submitted by neha2k· Apr 18, 2026Model the data

Question

You have a Microsoft Power Bl report. The size of PBIX file is 550 MB. The report is accessed by using an App workspace in shared capacity of powerbi.com. The report uses an imported dataset that contains one fact table. The fact table contains 12 million rows. The dataset is scheduled to refresh twice a day at 08:00 and 17:00. The report is a single page that contains 15 AppSource visuals and 10 default visuals. Users say that the report is slow to load the visuals when they access and interact with the report. You need to recommend a solution to improve the performance of the report. What should you recommend?

Options

  • AChange any DAX measures to use iterator functions.
  • BRemove unused columns from tables in the data model.
  • CIncrease the number of times that the dataset is refreshed.
  • DReplace the default visuals with AppSource visuals.

How the community answered

(30 responses)
  • A
    3% (1)
  • B
    77% (23)
  • C
    7% (2)
  • D
    13% (4)

Why each option

Removing unused columns from the data model directly reduces the overall model size and the amount of data processed, significantly improving report load and interaction performance.

AChange any DAX measures to use iterator functions.

Changing DAX measures to use iterator functions (e.g., SUMX) can sometimes be less performant than aggregate functions (e.g., SUM) if not applied correctly, and is not a universal solution for performance improvement.

BRemove unused columns from tables in the data model.Correct

Unused columns in a Power BI data model consume memory and storage without contributing to analysis, and their removal directly reduces model size, making queries faster and improving report load and interaction performance.

CIncrease the number of times that the dataset is refreshed.

Increasing the dataset refresh frequency only ensures data freshness and does not directly impact the speed at which the report loads or users interact with it.

DReplace the default visuals with AppSource visuals.

AppSource visuals (custom visuals) can sometimes be less optimized than default visuals and may even degrade performance, making this an unlikely solution for improving report speed.

Concept tested: Optimizing Power BI data model size and performance

Source: https://learn.microsoft.com/en-us/power-bi/guidance/report-performance-optimize-data-model

Topics

#Data model optimization#Report performance#Import mode#File size reduction

Community Discussion

No community discussion yet for this question.

Sign up to join the discussion
Full PL-300 Practice