Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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 |
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.
User | Count |
---|---|
67 | |
47 | |
21 | |
19 | |
15 |
User | Count |
---|---|
122 | |
42 | |
39 | |
26 | |
24 |