Need Help with Dynamic RLS

[DanduMani104]

Hi team , Im strugguled with Dynamic RLS in my Report.

I have used USERPRINCIPALNAME() for this.But My Report is not get filtered according to user ID assaign officess.

like this ..it is not get filtered

[v-zhengdxu-msft]

Hi @DanduMani104 

I have understood your question:

Your report did not get filtered according to user ID assaign officess after you configure the report RLS.

You can check if there are any relationships between your data models that can be safely filtered.

For example, I configure a RLS in my report:

The result is as follow:

But if I delete the relationship between the two data models, the result can be:

Or you can refer the following links to get help:

Dynamic Row-level Security in Power BI (databear.com)

Dynamic Row Level Security with Power BI Made Simple - RADACAD

Best Regards,

Zhengdong Xu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[DanduMani104]

but I have built the relationship like that  my user table is having active relation with my sales office table with Office key as a primary key and my sales office table is having active relation with my Fact tabe as below