Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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 |
---|---|
102 | |
88 | |
78 | |
71 | |
69 |
User | Count |
---|---|
113 | |
99 | |
97 | |
72 | |
68 |