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 |
