Daily DAX : Day 438 INFO.ROLEMEMBERSHIPS

Power BI DAX Function: INFO.ROLEMEMBERSHIPS

Description

The INFO.ROLEMEMBERSHIPS function is a DAX information function that returns a table listing all role memberships defined in the current data model.

It corresponds directly to the TMSCHEMA_ROLE_MEMBERSHIPS Dynamic Management View (DMV) in tabular models.

The returned table includes columns such as Role ID, Member Name (user or group), and other metadata matching the schema for role memberships.

Syntax

INFO.ROLEMEMBERSHIPS()

No parameters are required.

Key Characteristics

  • Returns a table (tabular result).
  • Can be used in DAX queries (e.g., in DAX Query View or tools like DAX Studio).
  • Cannot be used in calculated tables or calculated columns.
  • Requires model admin permissions in Power BI Service (similar to DMVs).
  • Performs context transition if called in a row context.
  • Its use is not recommended for regular reporting; it's primarily for metadata inspection.

Use Cases

  • Model Documentation & Auditing: Retrieve a complete list of users/groups assigned to each security role in the model.
  • Metadata Analysis: Query role memberships programmatically (e.g., via scripts or DAX Studio) for governance or compliance checks.
  • Development & Troubleshooting: Inspect how Row-Level Security (RLS) roles are configured with members during model development.
  • Automation: Combine with other INFO functions (like INFO.ROLES) to export or analyze security configurations across models.
Note: This function returns static role memberships defined in the model (users/groups added in Power BI Service or Desktop). It does not return the active roles for the current user during report viewing. For detecting active roles (useful in reports), alternative techniques exist, such as those described in SQLBI articles using custom measures.

Example Usage (in DAX Query View)

EVALUATE INFO.ROLEMEMBERSHIPS()

This query will return all role memberships in the model.

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