Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
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.
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
User | Count |
---|---|
102 | |
92 | |
85 | |
78 | |
71 |
User | Count |
---|---|
113 | |
104 | |
101 | |
73 | |
65 |