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 ...
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.
So.... Don't you have the answer to this problem?.... anyone else? please?