Join us for an expert-led overview of the tools and concepts you'll need to pass exam PL-300. The first session starts on June 11th. See you there!
Get registeredPower BI is turning 10! Let’s celebrate together with dataviz contests, interactive sessions, and giveaways. Register now.
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.
@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.
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.
@nandukrishnavs Yes require the level because needs to create matrix in the dashboard.
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.
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Power BI update to learn about new features.
User | Count |
---|---|
11 | |
7 | |
2 | |
2 | |
1 |
User | Count |
---|---|
3 | |
3 | |
3 | |
2 | |
2 |