BenchMark Quizzes by MDFT Pro

Improve Performance Of Production Model

You create a data model and report in Power BI Desktop to analyze student performance at MDFT Academy. The report runs well in the development environment, but when deployed to production, the model and report have performance issues.

You need to improve the model’s performance. What actions should you take to optimize the report for production use?

Choose all correct answers from the options below.

Explanations for each answer:

Remove columns not used in reports from the data model is correct. Removing unnecessary columns (vertical filtering) reduces model size and improves refresh time.
Hide columns in the data model is incorrect. Hidden columns are still processed and don't reduce model size or improve performance.
Summarize data and create aggregations is correct. Summarizing data is the most effective technique to reduce model size and improve performance.
Increase the refresh frequency of the dataset is incorrect. Increasing refresh frequency does not improve model performance; it only updates data more often.

Learn more about optimizing Power BI report performance:

Power BI Performance Optimization

Exam Preparation Quiz

Improve Performance Of Production Model