Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I have a certain scenario where I have to apply dynamic RLS. Here is the case- I have a user table
A location table
And a Sales table
I want to apply Row level security that if a certain user logs in using the Email he should not only see his data but also all the users who are also in the same location. So if you can see in above User table, UserID 1,2,3 all are from location 1(i.e. User 1,2,3). So if user 1 logs in he should see the data of all the people who are in location 1.
So please suggest how to apply Row level security for this scenario? What DAX formula or logic needs to be applied here?
Thank you!
Solved! Go to Solution.
You may check the post below.
You may check the post below.
Thank you Sam, that was helpful.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |