Dax Function: INFO Functions
Category: Parent and child functions
INFO functions in Power BI are DAX functions designed to retrieve metadata and information about the environment, model, or query execution. They are commonly used for diagnostics, debugging, or for gaining insights into the runtime behavior of Power BI datasets.
Purpose
The primary purpose of INFO functions is to enable users to extract information about their data model or query execution environment. This can include details about the current user, model version, or configuration settings, helping with troubleshooting and optimization.
| Function | Description |
|---|---|
| INFO.VIEW.COLUMNS | Provides a list of all columns present in the current model, suitable for use in calculations, including calculated tables. |
| INFO.VIEW.MEASURES | Displays a list of all measures within the current model, which can be utilized in calculations or calculated tables. |
| INFO.VIEW.RELATIONSHIPS | Generates a list of all relationships defined in the current model, applicable for use in calculations and calculated tables. |
| INFO.VIEW.TABLES | Retrieves a list of all tables in the current model, allowing integration into calculations, including calculated tables. |
| INFO.ANNOTATIONS | Outputs a list of all annotations in the current model, with columns aligned to the schema rowset for annotation objects. |
| INFO.CALCDEPENDENCY | Provides details about calculation dependencies relevant to a DAX query. |
Maximize the potential of Power BI and enhance your data insights with our expert consulting services. Whether you’re looking for assistance with advanced DAX functions, help designing interactive dashboards, or support in optimizing your data models for better performance, our skilled Power BI consultants are ready to provide tailored solutions for your business. Visit our Power BI consultancy page to learn more about how we can empower your organization to make more informed, data-driven decisions.
INFO functions provide metadata and runtime information about the Power BI environment and data model.
Common INFO functions include USERPRINCIPALNAME, USERNAME, and other diagnostic functions like ISINSCOPE.
INFO functions are useful for debugging, gaining insights about the user or model, and customizing reports based on user context.
Generally, they are lightweight, but improper use in large models or complex queries may lead to performance overhead.
Yes, functions like USERPRINCIPALNAME can help implement row-level security by filtering data based on the current user.