RLS Question

brankocareer — Tue, 14 Jan 2025 17:25:45 GMT

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

Re: RLS Question

lbendlin — Tue, 14 Jan 2025 21:51:32 GMT

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.

topic RLS Question in Report Server

RLS Question

Re: RLS Question