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 Dataviz World Championships
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Power BI Monthly Update - December 2025
Check out the December 2025 Power BI Holiday Recap!
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.
