Daily DAX : Day 424 INFO.MODEL

INFO.MODEL – DAX Function in Power BI

Syntax

INFO.MODEL()

Description

INFO.MODEL() is a system information function in DAX that returns a table containing metadata about the current data model.

It provides detailed information about every table, column, measure, hierarchy, and relationship in the Power BI (.pbix) or Analysis Services model.

Return Value

A table with the following columns:

Column Name	Description
ID	Unique internal identifier of the object
Name	Name of the table, column, measure, etc.
Type	Type of object: Table, Column, Measure, Hierarchy, Relationship, etc.
Description	Description (if any was entered in the model)
IsHidden	TRUE if the object is hidden from the report view
DataType	Data type (for columns)
Expression	DAX expression (for calculated columns and measures)
FormatString	Format string applied to the column/measure
TableID, FromColumn, ToColumn, etc.	Additional details for relationships

Common Use Cases

• Documenting the data model – Export all objects and their definitions to Excel/Power BI for documentation.
• Model auditing & governance – Find hidden objects, unused measures, or missing descriptions.
• Dynamic reporting on the model itself – Build reports that list all measures, tables, or relationships.
• Impact analysis – See which tables/columns are used in measures before deleting them.
• Automation scripts – Use in Power BI Desktop with DAX Studio or Tabular Editor scripts.

Example

// Returns a table with every object in the model
ModelObjects = INFO.MODEL()

// List only measures
MeasuresOnly = 
FILTER(
    INFO.MODEL(),
    [Type] = "Measure"
)

// Count how many measures exist
Measure Count = COUNTROWS(FILTER(INFO.MODEL(), [Type] = "Measure"))

Note:: INFO.MODEL() is only available in Power BI Desktop, Power BI Service (when using XMLA endpoint with tools like DAX Studio or Tabular Editor), and Azure Analysis Services / SQL Server Analysis Services Tabular models. It does does not work in Excel Power Pivot.