Performance Analyzer reports that a card visual spent 1,400 ms in one duration category and only 80 ms elsewhere. The semantic model uses Import storage mode. Which duration category most likely represents the 1,400 ms reading?
- AThe Direct query category, covering query time against the data source.
- BThe Visual display category, covering rendering and geocoding work.
- CThe Other category, covering query preparation and waiting work.
- DThe DAX query category, covering query time against the semantic model. Correct
Why A is wrong: Direct query only appears when a table uses DirectQuery storage mode; an Import model does not generate a Direct query duration.
Why B is wrong: Visual display covers drawing on screen and retrieving images; a single card with a number rarely spends 1,400 ms in render time.
Why C is wrong: Other covers query preparation and waiting on other visuals; it is rarely the dominant cost for an isolated card.
Why D is correct: Correct. On an Import model, the DAX query duration is the time between the visual sending the query and the semantic model returning results.