Forum Discussion
Row Level Security
I have to apply Row Level Security in power bi report. The data is hierarchical data where I have to create 4 roles, Global : having access to entire report, Division : having access to Division le...
Below is the example of the hierarchy of the structure of my data. In example I have used only 2 Divisions but in total I have 6 Divisions and couple of Sub-Divisions under each Division and lots of Enties for every sub-division.Hierarchy structure
Below is the snap of the table used for applying RLS. It has details such as Username, their details, Access_Type is the level they have access to and the Access_Value is the exact unit they should have access to. I have created an Entity column as well now where I have duplicated the data for every user havinh top levels of access based on every entity level view they should have.
Note: Entity is the lowest level in hierarchy.