topic Re: RLS code for dynamic hierarchical data in DAX Commands and Tips

RLS code for dynamic hierarchical data

VP_VishnuVS3 — Thu, 04 May 2023 12:12:43 GMT

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

Re: RLS code for dynamic hierarchical data

lbendlin — Sat, 06 May 2023 21:45:38 GMT

use PATHCONTAINS for the users' projects.

Re: RLS code for dynamic hierarchical data

jiaopengzi — Sun, 07 May 2023 10:44:53 GMT

You can try the tool I developed: pbi utils to achieve.

Download link:https://github.com/jiaopengzi/pbi-utils

Hope it can help you.

Re: RLS code for dynamic hierarchical data

lbendlin — Sun, 07 May 2023 12:04:26 GMT

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.