Forum Discussion
LOOKUPVALUE overrides RLS
Hi,
I have two tables:
ContactOrigin:
ContactDestiny:
Both tables are not related inside the model (even though they have the "Id Origin" in common). In Power BI, both tables have RLS applied on Company Id Origin and Company Id Destiny, respectively. So, when I apply RLS for the company with Id 80022233 (BBB Ltda), both tables are filtered and that's ok:
But what I need is the "Id Origin" field in Destiny Contact Table shows only values that belong to BBB Ltda in Contact Origin Table (in this case, "567890" doesn't belong to BBB Ltda in Origin Contact table). I tried to create a calculated column to solve this:
But the outcom is the same, which means that LOOKUPVALUE overrides the RLS security:
Is there another way to solve this issue? This is what I expected to see:
Thanks!
4 Replies
If you don't have an active relationship how is RLS supposed to know that it needs to filter the other table? In that case you need to apply the RLS rules to BOTH tables.
I put this case as simple as I can. In my real model, these two tables doesn't exists. In the real one, I have two tables which are filtered with RLS, but I need both unrelated. Maybe the following link will explain you this case better than me:
https://community.powerbi.com/t5/Desktop/Lookupvalue-override-RLS/td-p/579361
As I say, I just try to "simplified" the case. In the link above it's explained, but in essence, it is the same issue.
Answer is still the same. If the tables are unrelated then you need to apply the RLS rules twice, once for each table.
