Forum Discussion

psadav's avatar
psadav
Frequent Visitor
2 months ago
Solved

Dynamic AD Group-Based Row-Level Security (USERMEMBEROF()) in Power BI/Fabric

Hello Microsoft Power BI/Fabric Team and Community,   I am working on a large-scale Power BI solution in a Fabric F64 capacity workspace. My scenario requires dynamic row-level security (RLS) based...
General Comment
Tips and Tricks
Tutorial Requests
  • v-nmadadi-msft's avatar
    v-nmadadi-msft
    2 months ago

    Hi psadav ,
    If the requested feature is important for your functionality Please consider sharing your suggestion in the Power BI Ideas forum.
    Fabric Ideas - Microsoft Fabric Community
    where the product team actively monitors user feedback. Ideas with strong community support are more likely to be considered for future implementation. Posting there helps ensure your request reaches the right audience and contributes to shaping the product roadmap.
    Regards

william1234's avatar
william1234
Helper II
2 months ago

This is a valid enterprise use case, but currently Power BI RLS evaluates the user identity, not Entra ID group membership directly.

A common scalable workaround is to automate an access mapping table from Entra ID groups (using Graph API, Data Factory, Fabric pipelines, etc.) and keep RLS based on USERPRINCIPALNAME(). This avoids manually maintaining users while still allowing group-driven access changes.

For USERMEMBEROF() / Enhanced RLS availability, Microsoft has not published a general ETA. Your best options are to check with your Microsoft account team for preview availability and submit feedback through the Fabric Ideas portal.