The formula engine && of the storage engine in DAX

In order to enhance the optimization of our #DAX queries, we first need to understand the purpose of the formula engine && the storage engines and how they work.

When excuting DAX Queries, two engines are implicated:

✔The formula engine: used to execute and generate a query plan.

✔The storage engine: used to answer the requests made by the formula engine. This engine retrieves data from:
👉 👉 The VertPiaq engine: which store a copy of the data in memory when connecting to the dataset using the import mode
👉 👉 The original data source when using DirectQuery connection