Row Level Security - not displaying data for certain roles

[tarajohnstone]

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 slides and following the same naming conventions (and the data being present in the original dataset. I have tried copying the naming conventions straight from the extracted report, using the DAX editor and the defult editor with no success. 

All reports have the correct relationships in the model view and data displays for all other roles. 

Any ideas on how to fix this one?

Thank you

[tarajohnstone]

Thank you for your help, is was a problem with the 'role filters not cascading'. 

[v-saisrao-msft]

Hi @tarajohnstone 

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[v-saisrao-msft]

Hi @tarajohnstone,
I wanted to check if you had the opportunity to review the information provided by @Ritaf1983. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[Ritaf1983 · Accepted solution]

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