A Tabular model can be configured to use the DirectQuery mode to retrieve data from the underlying data source. In this mode, the data is not loaded into the model, but it is retrieved from the data source at query time.

Normally, DirectQuery provides a lower performance than Import models (VertiPaq).

DAX Optimizer can analyze DirectQuery models, but with some limitations, as it is optimized for Import models.

Last update: Apr 09, 2024