Hi,
I am trying to use RLS on a large dashboard with many, many tables.
Basically I have Employees who belong to contracts and I want the RLS to work such that someone assigned to that contract would see the data only relevant to their contracts.
There are some contractors that serve on multiple contracts but I am not sure how to set up the user roles.
I want people from Contract A to only be able to see Contract A, B to see B and so on.
I tried using this [Contract] = LOOKUPVALUE(Contract[Contract],Contract[Contractor Email],USERPRINCIPALNAME()) but it will repeat Dennis and you should only be able to select one contract at a time. Any insight would be greatly appreciated. Thanks
Helpful resources
Power BI Monthly Update - November 2025
Check out the November 2025 Power BI update to learn about new features.
Fabric Data Days
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
FabCon Atlanta 2026
Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
