Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

DirectQueryUsage Enumeration


Applies To: SQL Server 2016 Preview

Specifies the current DirectQuery usage of the partition.

Namespace:   Microsoft.AnalysisServices
Assembly:  Microsoft.AnalysisServices (in Microsoft.AnalysisServices.dll)

public enum DirectQueryUsage

Member nameDescription

Indicates that queries on the partition should use only the relational data source.


Indicates that queries on the partition should use only the in-memory data store.


Indicates that queries against the model can use either the xVelocity in-memory analytics engine (VertiPaq) cache, or the relational data store. The in-memory data store is preferred if both are available.

Only one partition can be enabled for DirectQuery access at a time. To use a partition in Direct Query mode, the storage mode of the model must have been previously changed to enable DirectQuery mode. For more information, see Partitions and DirectQuery Mode (SSAS Tabular).

Return to top

Community Additions

© 2015 Microsoft