Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
I'm trying to implement RLS in a datamodel with no apparent relationship between the user table and the transaction table.
I want all managers to be able to see all the data in the transaction table, and the non-managers to see no data.
Would this be possible?
User table:
User | IsManager | Username | |
A | 0 | a@mail.com | domain\a |
B | 1 | b@mail.com | domain\b |
C | 0 | c@mail.com | domain\c |
Transaction table:
Transaction ID | Value |
1 | 100 |
2 | 300 |
Solved! Go to Solution.
@nimp_kp , Create a new column in the transaction table and have value =1
user type =1
join this with IsManager (Many to many, Bi directional or use filter Fact)
Then create role with filter on user table
[Email] = userprincipalname()
@nimp_kp , Create a new column in the transaction table and have value =1
user type =1
join this with IsManager (Many to many, Bi directional or use filter Fact)
Then create role with filter on user table
[Email] = userprincipalname()
User | Count |
---|---|
139 | |
113 | |
104 | |
77 | |
63 |
User | Count |
---|---|
135 | |
126 | |
110 | |
70 | |
61 |