Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
hi,
currently i have a billing report that's using dynamic RLS to allow users to see the defined rows based on dept ownership.
If the access is given to one user i dont have a problem but using two there is an issue. Refer screenshots below.
Hi @nchandran ,
As mentioned by Payeras_BI, you should use [Bill Owner] = "TLee12; TSim3" and if you want to add more conditions in one role, you should use [Bill Owner] = "TLee12" || [Bill Owner] = "TSim3" instead of [Bill Owner] = "TLee12" && [Bill Owner] = "TSim3"
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Best Regards,
Dedmon Dai
Hi @nchandran ,
Wouldn't be that in your Table filter expression instead of this:
You wrote this:
[Bill Owner] = "TLee12; TSim3"
oh so i should change the expression to --> [Bill Owner] = "TLee12; TSim3" for the filter, ok i will try now.
Hi @nchandran ,
Did it work?
Regards,
We had to end up removing the roles because the two user needs to see the entire bill. Chckin with return back on this.
@nchandran , Not very clear Try || (Or) In place of && (and)
Are you saying on the excel Bill owner field? to change from A ; B to A && B?
User | Count |
---|---|
86 | |
84 | |
69 | |
67 | |
55 |
User | Count |
---|---|
125 | |
100 | |
90 | |
84 | |
66 |