Forum Discussion
RLS with groups on multiple levels
Hi All, I have a report where i would like to apply the following security (for a customer) Company owner can see all data Sales representative group level 1 with multiple users Sales repr...
In this scenario, I suggest you use a numeric Level Column. Then you can apply row level filter like:
Table[Level]>=LOOKUPVALUE(Table[Level],Table[UserName],USERNAME())
Or you can consider using SSAS multidimension model as source. You can create a hierarchy for Employee, then apply cell level and dimension security based defined roles. Please refer to docs below:
Roles and Permissions (Analysis Services)
Connect to SSAS Multidimensional Models in Power BI Desktop
Regards,
Hi Simon,
Could you provide me with a bit more information on how to implement it using this numeric level column?
Thanks for your help!