Edit

INFO.MODEL

Applies to: Calculated column Calculated table Measure Visual calculation DAX query

Returns a table with information about the model in the semantic model. This function provides metadata about the model itself and its properties.

Syntax

INFO.MODEL ( [<Restriction name>, <Restriction value>], ... )

Parameters

Parameters are optional for this DAX function. When parameters are used, both must be given. More than one pair of parameters is allowed. The restriction name and value are text and entered in double-quotes.

Term Definition
Restriction name Name of the restriction used to filter the results.
Restriction value Value used to filter the results of the restriction.

Restrictions

Typically, all columns of the DAX function results can be used as a restriction. Additional restrictions may also be allowed.

Return value

A table with the following columns:

Column Data Type Description
[ID] Integer Unique identifier for the model
[Name] String Name of the model
[Description] String Description of the model
[StorageLocation] Integer Storage location indicator
[DefaultMode] Integer Default processing mode for the model
[DefaultDataView] Integer Default data view setting
[Culture] String Culture identifier for the model (e.g., "en-US")
[Collation] String Collation setting for the model
[ModifiedTime] DateTime Date and time when the model was last modified
[StructureModifiedTime] DateTime Date and time when the model structure was last modified
[Version] Integer Version number of the model
[DataAccessOptions] String JSON object containing data access configuration options
[DefaultMeasureID] Integer ID of the default measure, if any
[DefaultPowerBIDataSourceVersion] Integer Default Power BI data source version
[ForceUniqueNames] Boolean Whether unique names are enforced
[DiscourageImplicitMeasures] Boolean Whether implicit measures are discouraged
[DataSourceVariablesOverrideBehavior] Integer Behavior for data source variable overrides
[DataSourceDefaultMaxConnections] Integer Default maximum connections for data sources
[SourceQueryCulture] String Culture used for source queries
[MAttributes] String Model attributes
[DiscourageCompositeModels] Boolean Whether composite models are discouraged
[AutomaticAggregationOptions] String Options for automatic aggregations
[DisableAutoExists] Integer Auto exists disable setting
[VersionMarker] String Version marker for the model

Remarks

  • Typically used in DAX queries to inspect and document model metadata.
  • Permissions required depend on the host. Querying full metadata may require model admin permissions.

Example

The following DAX query can be run in DAX query view:

EVALUATE
	INFO.MODEL()

See also