27.2 Performance Analyzer
- Optimize › Performance analyzer (in older versions: View › Performance analyzer).
- Click Start recording, then Refresh visuals (or interact with slicers).
- Each visual is listed with its duration in milliseconds, split into:
| Part | Meaning |
|---|---|
| DAX query | Time for the engine to run the query – high values point to the model or DAX |
| Visual display | Time to draw the visual – high for visuals with many data points or custom visuals |
| Other | Waiting time (e.g. for other visuals) and preparation work |
| Direct query | (DirectQuery only) Time spent waiting for the source database |
- Expand a visual and click Copy query to analyse the DAX in DAX query view or in the free community tool DAX Studio.
- Export saves the results as a JSON file.
Test fairly
Mitrano, test from a blank page first (so caches are not already warm), then switch to the page you want to measure. Compare before/after timings for each change you make.
Performance Analyzer ha doctor sarkha aahe – aadhi nidan, mag ilaj.
Ravindra Bagale's Tip
A common Performance Analyzer mistake is recording once with a warm cache and trusting the numbers. Click Refresh visuals while recording, test a few times, and look at DAX query vs Visual display vs Other to know whether the problem is the model, the visual or too many visuals. Don't worry – after doing it two or three times, it becomes a habit.
Ravindra Bagale's Tip – मराठी
Performance Analyzer मधली एक common चूक म्हणजे warm cache असताना एकदाच record करून त्या numbers वर विश्वास ठेवणं. Record करताना Refresh visuals click करा, काही वेळा test करा, आणि problem model मध्ये आहे, visual मध्ये आहे की visuals खूप जास्त आहेत हे कळण्यासाठी DAX query vs Visual display vs Other बघा. घाबरू नका, दोन-तीन वेळा केलं की सवय होते.
Ravindra Bagale's Tip – हिंदी
Performance Analyzer की एक common गलती है warm cache के साथ एक बार record करके उन numbers पर भरोसा कर लेना. Record करते समय Refresh visuals click करो, कुछ बार test करो, और DAX query vs Visual display vs Other देखो ताकि पता चले कि problem model में है, visual में है या visuals बहुत ज़्यादा हैं. घबराओ मत, दो-तीन बार करने पर आदत हो जाती है.