DirectQueryUsage Enum
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Specifies the current DirectQuery usage of the partition.
public enum DirectQueryUsagetype DirectQueryUsage = Public Enum DirectQueryUsage- Inheritance
-
DirectQueryUsage
Fields
| Name | Value | Description |
|---|---|---|
| InMemoryWithDirectQuery | 0 | 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. |
| InMemoryOnly | 1 | Indicates that queries on the partition should use only the in-memory data store. |
| DirectQueryOnly | 2 | Indicates that queries on the partition should use only the relational data source. |
Remarks
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).