Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
nimp_kp
Frequent Visitor

RLS with no relationship

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:

UserIsManagerEmailUsername
A0a@mail.comdomain\a
B1b@mail.comdomain\b
C0c@mail.comdomain\c

 

Transaction table:

Transaction IDValue
1100
2300
1 ACCEPTED SOLUTION
amitchandak
Super User
Super User

@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()

View solution in original post

1 REPLY 1
amitchandak
Super User
Super User

@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()

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.