Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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()
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
97 | |
84 | |
67 | |
59 |
User | Count |
---|---|
150 | |
120 | |
99 | |
87 | |
68 |