Daily DAX : Day 432 INFO.REFRESHPOLICIES

Power BI DAX Function: INFO.REFRESHPOLICIES()

Overview

INFO.REFRESHPOLICIES() is one of the new INFO DAX functions introduced in Power BI's DAX query view (available since late 2023). These INFO functions provide metadata about the semantic model (dataset), similar to Dynamic Management Views (DMVs) in Analysis Services.

Specifically, INFO.REFRESHPOLICIES() returns a table containing information about the incremental refresh policies configured on tables in the current semantic model.

Syntax

INFO.REFRESHPOLICIES()

This function takes no parameters and returns a table with columns detailing the refresh policies (e.g., table ID, policy type, rolling window periods, etc.).

Use Cases

  • Model Documentation: Query and document which tables have incremental refresh policies applied, including details like historical and incremental periods.
  • Auditing and Troubleshooting: Verify incremental refresh configurations in published datasets, especially when diagnosing refresh performance issues or partition problems.
  • Metadata Analysis: Use in DAX queries (via DAX Query View in Power BI Desktop/Service, DAX Studio, or external tools like Excel) to inspect model metadata without needing XMLA endpoint access.
  • Reporting on Model Structure: Build reports or visuals showing refresh policy details across tables in large/complex models.

Example Query

You can run this in DAX Query View or DAX Studio:

EVALUATE INFO.REFRESHPOLICIES()

This will return rows for each table with an incremental refresh policy, including columns such as policy settings, source expressions, and partition details.

Notes

  • Available in Power BI semantic models supporting DAX query view.
  • Part of over 50 INFO functions mapping to TMSCHEMA DMVs.
  • Useful for advanced users managing large datasets with incremental refresh.


Comments

Post a Comment

Popular posts from this blog

Daily DAX : Day 131 SELECTEDMEASURE

 The SELECTEDMEASURE function in Power BI's DAX (Data Analysis Expressions) language is a powerful tool used primarily within calculation groups to dynamically reference the measure currently being evaluated in a report. It’s part of the calculation group feature introduced to streamline complex reporting scenarios and improve maintainability by reducing the need to duplicate measure logic. What is SELECTEDMEASURE? SELECTEDMEASURE is a DAX function that returns a reference to the measure that is currently active or "selected" in the context of a calculation group. It doesn’t take any arguments and is typically used in the expression of a calculation item within a calculation group. This allows you to write generic logic that can dynamically apply to whichever measure is being evaluated in a visual, without hardcoding specific measure names. Syntax SELECTEDMEASURE()     Returns: A reference to the measure currently being evaluated in the report context. Use Case SELECTEDME...
Read more

Daily DAX : Day 446 INFO.CSDLMETADATA

Power BI DAX Function: INFO.CSDLMETADATA INFO.CSDLMETADATA` is a specialized DAX function introduced as part of a broader set of "INFO" functions (like `INFO.TABLES` or `INFO.MEASURES`) used for **model introspection**. It allows you to programmatically access the underlying structure of your Power BI semantic model. What does it do? The function returns a table with a single column containing the Conceptual Schema Definition Language (CSDL)  metadata of your model in XML format . In plain English, it exports a highly technical "blueprint" of your entire data model—including tables, columns, relationships, and measures—as a structured XML string. It is essentially the DAX equivalent of the `DISCOVER_CSDL_METADATA` Dynamic Management View (DMV) used in Analysis Services. --- Syntax and Output The syntax is straightforward as it requires no arguments: ```dax EVALUATE INFO.CSDLMETADATA() ``` Return Value : A table with one column and one row. Content : A long string ...
Read more

Daily DAX : Day 126 USERPRINCIPALNAME

 The USERPRINCIPALNAME function in Power BI's DAX (Data Analysis Expressions) language is used to return the user principal name of the current user accessing the report. Here's a breakdown: Function Syntax: USERPRINCIPALNAME() Explanation:     User Principal Name (UPN): This is essentially an Internet-style login name for the user based on the Internet standard RFC 822. It typically has the format username@domain.com. Main Use Cases:     Row-Level Security (RLS):         One of the primary uses of USERPRINCIPALNAME() is in implementing row-level security within Power BI. You can use this function to dynamically filter data based on who is viewing the report. For instance, you might restrict access so that users only see data pertinent to themselves or their specific department by comparing the UPN with a column in your data model.     Example:     DAX     SecurityFilter =      'User'[UserPrincipal...
Read more