© Philip Seamark, Thomas Martens 2019
P. Seamark, T. MartensPro DAX with Power BIhttps://doi.org/10.1007/978-1-4842-4897-3_13

13. Query Plans

Philip Seamark1  and Thomas Martens2
(1)
UPPER HUTT, New Zealand
(2)
Hamburg, Hamburg, Germany
 

Introduction to Query Plans

A handy feature of the DAX engine is the ability to access a useful piece of information called a Query Plan. A Query Plan provides insight into the inner workings of how the DAX engine goes about its task to deliver results requested by any given DAX query.

A real-world comparison might be to provide a breakdown of tasks required to complete a particular project. If the project was to build a birdhouse, a project plan could get generated before starting, being updated along the way once specific ...

Get Pro DAX with Power BI: Business Intelligence with PowerPivot and SQL Server Analysis Services Tabular now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.