PL-300 · Question #260
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 C. Remove unused columns from tables in the data model. To improve the performance of a slow Power BI report, especially with a large imported dataset, it is crucial to optimize the data model by removing unnecessary columns.
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
- AReplace the default visuals with AppSource visuals.
- BChange any DAX measures to use iterator functions.
- CRemove unused columns from tables in the data model.
- DIncrease the number of times that the dataset is refreshed
How the community answered
(22 responses)- A18% (4)
- B5% (1)
- C68% (15)
- D9% (2)
Why each option
To improve the performance of a slow Power BI report, especially with a large imported dataset, it is crucial to optimize the data model by removing unnecessary columns.
Replacing default visuals with AppSource visuals is unlikely to improve performance and may even degrade it, as AppSource visuals can sometimes be more resource-intensive than native visuals.
While optimizing DAX measures is important, changing measures to use iterator functions (e.g., SUMX) is a specific optimization technique that might not be universally applicable or the primary cause of broad slow loading across all visuals; it depends on the specific measure logic.
Removing unused columns from tables in the data model significantly reduces the overall size of the dataset, which directly translates to faster report loading, quicker visual rendering, and improved interactivity, particularly for reports with large fact tables and high row counts. A smaller data model consumes less memory and allows for more efficient query processing.
Increasing the number of times the dataset is refreshed will not improve report loading or interaction performance; it only means the data will be more current but does not address the underlying performance issue of the report itself.
Concept tested: Optimizing Power BI data models by removing unused columns
Source: https://learn.microsoft.com/en-us/power-bi/guidance/report-best-practices-data-reduction#remove-unnecessary-columns
Community Discussion
No community discussion yet for this question.