Forum Discussion
RLS code for dynamic hierarchical data
Hi,
We need to create a dynamic hierarchy RLS for a project. Which is having mutltiple Projects, their respective parent project id and users. When a user log in, the person need to see all the project assigned and the child projects.
We have refered Radacad link https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi, but it is not working for our scenario because an user will be having multiple projects assigned. Could you please help.
Please see the table of sample data and Expected result for user b is all the projects in the table and for user a is projects ids are 1, 3, 4 and 6
| projectsid | name | User | parentproject | Path |
| 1 | Test Project 1 | a | 1 | |
| 1 | Test Project 1 | b | 1 | |
| 2 | Test Project 2 | b | 2 | |
| 3 | Test Project 3 | b | 2 | 2|3 |
| 3 | Test Project 3 | a | 2 | 2|3 |
| 4 | Test Project 4 | c | 3 | 2|3|4 |
| 5 | Test Project 5 | d | 2 | 2|5 |
| 6 | Test Project 6 | e | 3 | 2|3|6 |
3 Replies
You can try the tool I developed: pbi utils to achieve.
Download link:https://github.com/jiaopengzi/pbi-utils
Hope it can help you.Nice work. It would be better not to use the term "permissions" for page navigation. As you know there is no such thing as page level security.
use PATHCONTAINS for the users' projects.
