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