Forum Discussion
Row Level Security - not displaying data for certain roles
- 1 year ago
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:
-
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. -
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 usingTREATAS()or reviewing filter context withFILTERS()in DAX. -
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=2sIf this post helps, then please consider Accepting it as the solution to help the other members find it more quickly
-
Thank you for your help, is was a problem with the 'role filters not cascading'.