Microsoft · PL-300
Optimize model performance
PL-300 · Lesson 8 of 15 · 50:15
YouTube loads only after you press play. This chapter opens at its timestamp in the full course. Watch on YouTube ↗
In this lesson
Prepare for the PL-300 exam (Microsoft Certified: Power BI Data Analyst Associate). In this lesson: removing unnecessary rows and columns, reducing granularity, Performance Analyzer and its DAX query, visual display, and other durations, and DAX query view with EVALUATE, DEFINE, and Update model with changes. Includes three original practice questions.
Preview the topics
- A model stores a free-text Comments column, with millions of different values, and no report uses it. The model is too large. What should the analyst do first?
- Reports only show sales by day, store, and product, yet the Sales table holds forty million receipt lines, and refreshes take hours. Which change reduces the model the most?
- Performance Analyzer shows a table visual that spends 1,800 ms in visual display, and only 200 ms in DAX query. What should the analyst change first?