Forum Discussion

tarajohnstone's avatar
tarajohnstone
New Member
1 year ago
Solved

Row Level Security - not displaying data for certain roles

I have just gone through and done a spot check of the Row Level Security roles that have been created.    Some of the roles are not displaying data on two of the slides despite working on all other...
  • Ritaf1983's avatar
    1 year ago

    Hi tarajohnstone 

    If data is not displaying for specific RLS roles despite being available in the source and showing correctly for other roles, there's very likely an issue with the relationships — even if they appear correct in the model view.

    Here are a few things worth double-checking:

    1. Relationship Direction & Filtering:
      Ensure the relationships between your dimension tables (like users or permissions) and the fact tables are single-directional and set to filter correctly in the direction your RLS logic expects. Even one missing filter path can block data.

    2. Role Filters Not Cascading:
      Sometimes, the RLS filter applied to one table doesn’t propagate as expected due to inactive relationships or because the filtering table isn’t in the path of the visual. You can test propagation by using TREATAS() or reviewing filter context with FILTERS() in DAX.

    3. Check for Conflicting Filters on the Page:
      If the data only fails to show on some slides, check whether visuals on those pages have conflicting visual/page/report filters that clash with the RLS filter logic.

    Try this video may be it will help :
    https://www.youtube.com/watch?v=-MwysbrdVO0&t=2s

    If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly