cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
nisha
Helper I
Helper I

How to create dynamic path for role level security.

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:

 

nisha_0-1626070390492.png

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.

 

nisha_1-1626070511420.png

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.

 

7 REPLIES 7
nandukrishnavs
Community Champion
Community Champion

@nisha 

 

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

nandukrishnavs_0-1626078773147.png

 

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!

 

@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.

 

nisha_0-1626080899692.png

 

@nisha Can you share your pbix file?

 

Do you really require Level 1 in the visual?

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

@nisha 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.

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

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.

nisha_0-1626155999375.png

 

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

Power BI October Update 2021.jpg

Power BI Release

Click here to read more about the October 2021 Release!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Teds Dev Camp Oct. 2021 768x460.jpg

Power BI Dev Camp - October 28th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

Top Solution Authors