RLS - Restriction based on granular / aggregate data
Organisational privacy policies requires that director level should not have access to granular data. Eg. which employee working timings.
Directors should only have access to aggregate data reports. Eg. Total sum of Overtime hours in a department.
The only way to achive this now is to have 2 separate PBI reports. Additionally, director reports should only have aggregate charts and "Build permission for the underlying dataset" should be disabled.
The ideal solution, each Role in RLS, will have an option "Access to granular data". If granular data access is not given, then all detailed tables, showing granular data will be masked out.