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 level, subdivision : having access to Subdivisions under the Divisions & lastly Entity: having access to only entities under a specific subdivision. I have a table where I have the details of the members describing who will have what level access & their email addresses. The table having the user details is called User_Access having columns 1.Username: name of the employee 2.Email: email address of the employee 3.Access Type: which level of access does the employee have; Global, Division, subdivision or Entity(hierarchy global being the top & entity being the lowest) 4.Access Value: which particular segment the employee has access to; Global has all, Division has for one of the divisions eg: Matt has access to entire ABC Division whereas Rainer has access to entire PQR division. 5.AccessKey: This column is a key created by combining the Divison-SubDivision-Entity to understand and have clear understanding of the level of access for each employees. Eg; Stephan has access to Entity UK level meaning he should view data for only that particular entity which comes under ABC as division & Europe as sub-division, so his AccessKey will be ABC-Europe-UK.
How do I apply RLS to such hierarchy?
3 Replies
Hi rutujakadam_11 ,
For Hierarchy RLS, you can check the following link, I hope it helps you:
Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD
Dynamic Row Level Security with Manager Level Access in Power BI - RADACAD
Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data. We can better understand the problem and help you.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi, I have shared the sample data for reference along with the original problem statement.
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.
