From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Unlock this course with a free trial

Join today to access over 24,900 courses taught by industry experts.

Identify poorly performing measures, relationships, and visuals

Identify poorly performing measures, relationships, and visuals - Power BI Tutorial

From the course: Microsoft Power BI Data Analyst Associate (PL-300) Cert Prep by Microsoft Press

Start my 1-month free trial Buy for my team

Identify poorly performing measures, relationships, and visuals

“

- [Instructor] In this sub-lesson, we're going to identify poorly performing measures, relationships, and visuals by using Performance Analyzer and DAX query view. You can use Performance Analyzer in Power BI Desktop to help you find out how each of your report elements are performing when users interact with them and which aspects of performance are most or least resource intensive. First, we want to ensure that we start with a clear visual and data engine cache. The visual cache is when you load a visual, you can't clear this visual cache without closing the Power BI Desktop first, and the data engine cache is when a query's run, the results are cached, so the results of your analysis will be misleading. We first want to clear the data engine cache before rerunning the visuals. So what we're going to do first is we're going to go ahead and get a Power BI Desktop file open to a blank page, and then run our Performance Analyzer to ensure that both visual caches are cleared. So in…

Contents