Dynamic Role based problem based on ldap

[nchandran]

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.

Working RoleWorking RLSNot Working RoleNot Working RLSFiltering based on Bill owner on datasource

[v-deddai1-msft]

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

[Payeras_BI]

Hi @nchandran ,

Wouldn't be that in your Table filter expression instead of this:

You wrote this:

[Bill Owner] = "TLee12; TSim3"

[nchandran]

oh so i should change the expression to --> [Bill Owner] = "TLee12; TSim3" for the filter, ok i will try now.

[Payeras_BI]

Hi @nchandran ,

Did it work?

Regards,

[nchandran]

We had to end up removing the roles because the two user needs to see the entire bill. Chckin with return back on this.

[amitchandak]

@nchandran , Not very clear Try || (Or) In place of && (and)

[nchandran]

Are you saying on the excel Bill owner field? to change from A ; B to A && B?