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

DirectQueryMode Enumeration

Indicates whether a tabular model is enabled for use in Direct Query mode.

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

public enum DirectQueryMode

Member nameDescription
DirectQueryIndicates that queries against the model should reference only the relational data source.
DirectQueryWithInMemoryIndicates that queries against the model should reference primarily the relational data source but can use the cache if available.
InMemoryIndicates that queries against the model should use only the in-memory data store.
InMemoryWithDirectQueryIndicates that queries against the model should reference the xVelocity in-memory analytics engine (VertiPaq) cache first, and then the relational data source.

After the model has been enabled for Direct Query access, you must also set a property on the data source that specifies whether to use Direct Query only, or to use a hybrid mode. For more information, see DirectQuery Mode (SSAS Tabular).

Community Additions

Show:
© 2015 Microsoft