INFO.MODEL DAX Function (Information)

Syntax  |  Return values  |  Remarks  

Represents the TMSCHEMA_MODEL DMV query function.

Syntax

INFO.MODEL ( [<RestrictionName> [, [<RestrictionValue>] [, <RestrictionName> [, [<RestrictionValue>] [, … ] ] ] ] ] )

Parameter	Attributes	Description
RestrictionName	Optional Repeatable	Restriction name.
RestrictionValue	Optional Repeatable	Restriction value.

Return values

Table An entire table or a table with one or more columns.

Field	Type
ID	Integer
Name	String
Description	String
StorageLocation	String
DefaultMode	Integer
DefaultDataView	Integer
Culture	String
Collation	String
ModifiedTime	DateTime
StructureModifiedTime	DateTime
Version	Integer
DataAccessOptions	String
DefaultMeasureID	Integer
DefaultPowerBIDataSourceVersion	Integer
ForceUniqueNames	Boolean
DiscourageImplicitMeasures	Boolean
DataSourceVariablesOverrideBehavior	Integer
DataSourceDefaultMaxConnections	Integer
SourceQueryCulture	String
MAttributes	String
DiscourageCompositeModels	Boolean
AutomaticAggregationOptions	String
DisableAutoExists	Integer
MaxParallelismPerRefresh	Integer
MaxParallelismPerQuery	Integer
DirectLakeBehavior	Integer
ValueFilterBehavior	Integer

Remarks

Corresponds to the TMSCHEMA_MODEL data management view (DMV).

As all the INFO functions, it cannot be used in calculated tables and calculated columns.

Last update: Oct 22, 2025   » Contribute   » Show contributors

Contributors: Alberto Ferrari, Marco Russo

Microsoft documentation not available.
The function may be undocumented or unsupported. Check the Compatibility box on this page.