RLS Question

[brankocareer]

Hi Power BI Guru,

I am new to RLS.  I created a security table contain 2 columns [Email Address] and [Brach Code], aming to create a dynamic RLS rule: the user can only see his own branch's information. Currently the branch code is uniq, and the relation is 1 to 1. The RLS rule works well at this moment.

However, I want to add more person into security table, the branch code is not uniq, the relation is changed to 1 to many, then the RLS rule doesn't work. I don't kow why. And how to address the issue?

Thank you in advance!

Branko

[lbendlin · Accepted solution]

The first version doesn't work either.  RLS requires that its restrictions impact the rest of the data model.  You need to change your joins to single direction, from the Security table to the Branch Master table. Make the second link Many To Many but only single direction.