DirectQuery in SQL Server 2016 Analysis Services

← Back to document page

DirectQuery in SQL Server 2016 Analysis Services Technical White Paper Published: January 2017 Applies to: Microsoft SQL Server 2016 Analysis Services , Tabular Summary: DirectQuery transforms the Microsoft SQL Server Analysis Services Tabular model into a metadata layer on top of an external database. For SQL Server 2016 , DirectQuery was redesigned for dramatically improved speed and performance, however, it is also now more complex to understand and implement. There are many tradeoffs to consider when deciding when to use DirectQuery versus in-memory mode (VertiPaq).

A SQL Server Analysis Services (SSAS) Tabular database is a semantic model that usually keeps a copy of the data in an in-memory columnar database, which reads data from data sources, processes them into its

  Services, Analysis, 2016, Server, Sql server analysis services, Directquery in sql server 2016 analysis services, Directquery