通过

2.2.5.1 Model Object

The Model object represents the Tabular data model. It is a child of the Database object as defined in [MS-SSAS]. All other Tabular metadata objects are descendants of the Model object.

The Model object has the following properties.

Name

Type

Description

ID

unsignedLong

A reference to the object.

Name

string

The name of the object.

Description

string

The description of the object.

StorageLocation<3>

string

The location on disk to place the model.

DefaultMode

long

The default method for making data available in the partition.

DefaultDataView

enumeration

Determines which partitions are to be selected to run queries against the model. The possible values are as follows:

  • Full (0) – Partitions with DataView set to "Default" or "Full" are selected.

  • Sample (1) – Partitions with DataView set to "Default" or "Sample" are selected.

  • Default (3) – Not applicable to Model.

Culture

string

The culture name to use for formatting.<4>

Collation

string

The collation sequence.

ModifiedTime

dateTime

The time that the object was last modified.

StructureModifiedTime

dateTime

The time that the structure of the object was last modified.

Version

long

The current version of the Model object. The version number is incremented when any transaction on the Model is committed. This version number is set to 1 for any newly created Tabular databases and is always set to 1 for all Tabular databases when the server is restarted.

DataAccessOptions<5>

string

A JSON property bag that contains the following three Boolean properties:

  • fastCombine – A Boolean that indicates the ability to override privacy levels to share data across data sources and queries.

    • If set to "true", data from data sources is allowed to be sent in queries to other data sources, regardless of the other data sources' privacy levels.

    • If set to "false", possible data sharing is controlled by the data source's privacy levels.

  • legacyRedirects – A Boolean that indicates whether unsafe redirects to a different site and from HTTPS to HTTP are enabled.

    • If set to "true", unsafe redirects are enabled; otherwise, it is "false".

  • returnErrorValuesAsNull – A Boolean that indicates whether individual cell errors are returned as null values or the query fails.

    • If set to "true", individual cell errors are returned as null values.

    • If set to "false", the query fails.

The default value for these Boolean properties is "false".

Compatibility level 1400 or higher is required.

DefaultMeasureID<6>

unsignedLong

An ID-based reference to the default measure of the Model object.

Compatibility level 1400 or higher is required.

ForceUniqueNames<7>

boolean

A Boolean that determines whether a measure can have the same name as any column in the model.

  • If set to "true", a measure cannot have the same name as any column in the model.

  • If set to "false", this restriction is not enforced.

Compatibility level 1500 or higher is required.

DiscourageImplicitMeasures<8>

boolean

A Boolean that determines whether to discourage the implicit measures.

  • If set to "true", implicit measures are discouraged.

  • If set to "false", implicit measures are not discouraged.

Compatibility level 1500 or higher is required.

DataSourceDefaultMaxConnections<9>

int

The default value for the MaxConnections property of the DataSource object when the object does not specify that value explicitly.

Compatibility level 1600 or higher is required.

SourceQueryCulture<10>

string

The name of the culture to be used when formatting during refresh through M.

Compatibility level 1600 or higher is required.

MAttributes<11>

string

A set of optional properties that can be used to define the literal attributes on the section members of the M queries.

Compatibility level 1600 or higher is required.

DiscourageCompositeModels<12>

boolean

A Boolean that indicates whether composite models usage is discouraged.

Compatibility level 1600 or higher is required.

AutomaticAggregationOptions<13>

string

A set of options for the automatic-aggregation subsystem.

Compatibility level 1600 or higher is required.

MaxParallelismPerRefresh<14>

int

The default value for number of concurrent jobs in data refresh. The command SEQUENCE can override the property using the MaxParallelism field.

Compatibility level 1600 or higher is required.

MaxParallelismPerQuery<15>

int

The maximum degree of parallelism for a query when connecting to data sources using DirectQuery.

Compatibility level 1600 or higher is required.

DefaultPowerBIDataSourceVersion<16>

enumeration

Defines the storage mode of the M expressions used by Power BI Service Semantic Models. The following are the supported values:

  • PowerBI_V1 (0) – Default value

  • PowerBI V2 (1) – The model stores the M Expressions using the Expressions property of the Model.

  • PowerBI_V3 (2) – The model stores the M Expressions using the Expressions property of the Model and DataSource.

Compatibility level of 1450 or higher is required. Value (2) requires a compatibility level of 1465 or higher.

DirectLakeBehavior<17>

enumeration

Defines the fallback behavior of Direct Lake tables using the following values:

  • 0 – Dynamic fallback depending on the data source capabilities

  • 1 – Direct Lake only

  • 2 – Direct Query only

Compatibility level 1604 or higher is required.

ValueFilterBehavior<18>

enumeration

Defines the behavior of value filters in the SummarizeColumns() DAX function. Allowed values are:

  • Coalesce – All value filters on the same table are applied together in a coalesced fashion.

  • Independent – Value filters on the same table are applied independently.

  • Automatic – Coalesce or Independent are automatically determined.

Compatibility level 1606 or higher is required.

SelectionExpressionBehavior<19>

enumeration

An enumeration that defines the behavior of selection expressions on calculation groups using the following values:

  • NonVisual (0) – Calculation group columns are marked as non-aggregatable in CSDL. When MultipleOrEmptySelectionExpression is not defined on a calculation group, multiple and empty selections will not apply any calculation items to the selected measure.

  • Visual (1) – Calculation group columns are marked as aggregatable in CSDL. When MultipleOrEmptySelectionExpression is not defined on a calculation group, multiple and empty selections will evaluate to BLANK() rather than evaluate to the selected measure.

  • Automatic (3) – Same effective behavior as "NonVisual". In the future, a higher compatibility level will automatically change the effective behavior to "Visual".

Compatibility level 1609 or higher is required.

VersionMarker<20>

string

The marker that serves as an indication of the version of the metadata of the Model. The marker is updated when any transaction on the Model is committed.

  • Last updated on