Chapter 9. Using DirectQuery

As you saw in Chapter 1, “Introducing the tabular model,” you can deploy a tabular model using either in-memory mode (VertiPaq) or pass-through SQL queries to relational sources (DirectQuery). This chapter covers the DirectQuery storage mode. You will learn how to configure DirectQuery, what are the limitations in a data model with regard to supporting DirectQuery, and what to consider before deciding whether to adopt DirectQuery.

You can apply DirectQuery to a model that was originally defined using VertiPaq. However, this is possible only if the model does not have any of the unsupported features. Therefore, it is important to be aware of the features that would disallow a switch to DirectQuery mode if you want ...

Get Tabular Modeling in Microsoft SQL Server Analysis Services, Second Edition now with the O’Reilly learning platform.

O’Reilly members experience live online training, plus books, videos, and digital content from nearly 200 publishers.