topic How to create dynamic path for role level security. in Developer

How to create dynamic path for role level security.

Anonymous — Mon, 12 Jul 2021 06:19:15 GMT

Hi All,

I have a requirement where i have to create role level security as per organization structure. I tried doing this using PATH function. However, got stuck in below scenario:

In case when Amy login he should only see the data for himself and Lindsay, But in my current development I am getting below output.

It should not show Reza Rad.

I am gusseing this is happening because in the PATH column, it generated 1|5|8, How can I create such path which is dynamic. i.e.

if Amy logs in he should get data only for those which are below not for above one.

Kindly help.

Re: How to create dynamic path for role level security.

nandukrishnavs — Mon, 12 Jul 2021 08:34:11 GMT

@Anonymous

Try the below logic in the RLS.

VAR _email = USERPRINCIPALNAME() VAR _id = CALCULATE(SELECTEDVALUE('Table'[ID] ),FILTER('Table',[Email]=_email)) VAR _resultFilter = PATHCONTAINS([Path],_id) return _resultFilter

Please find the attached pbix file.

Regards,
Nandu Krishna

Did I answer your question? Mark my post as a solution!
Appreciate with a kudos 👍

Proud to be a Super User!

Re: How to create dynamic path for role level security.

Anonymous — Mon, 12 Jul 2021 09:10:17 GMT

@nandukrishnavs Thanks for you response. However, the solution which you provided is the same which I already have. My issue is If Amy logs in Reza Rad should not appear.

Re: How to create dynamic path for role level security.

nandukrishnavs — Mon, 12 Jul 2021 09:34:58 GMT

@Anonymous Can you share your pbix file?

Do you really require Level 1 in the visual?

Re: How to create dynamic path for role level security.

Anonymous — Mon, 12 Jul 2021 10:19:38 GMT

@nandukrishnavs Yes require the level because needs to create matrix in the dashboard.

Re: How to create dynamic path for role level security.

Anonymous — Mon, 12 Jul 2021 10:20:51 GMT

How to attach pbix file. Unable to find the icon.

Re: How to create dynamic path for role level security.

nandukrishnavs — Mon, 12 Jul 2021 11:07:16 GMT

@Anonymous Can you generalize the logic? Why can't you use Level 2 and Level 3? Then you will not see "Reza Rad" right? Suppose if Reza Rad login what should be the results? If you could provide more examples, we can try.

Re: How to create dynamic path for role level security.

Anonymous — Tue, 13 Jul 2021 06:03:42 GMT

Hi,

Looks like I dont have permission to attached pbix file. However, my requirement is, I have to create a matrix which will have all the levels. For example. In my case I have 3 level. Now issue is whenever Reza and Leila login they will see correct data. However, when Others logins, they will get Level 1 value as well. For example: If Bill login he will see Leila and Mark as well. I dont want to show higher level data. It should filter out.