RLS 2 table filter

[Anonymous]

Dearl All,

I have an issue with rls. I have SalesPersons, and I want to share them the reports. But the reports were created from 2 tables. So like the first sheet of the report from a Sales table, and the other sheet of the report from GL table. Both tables have SalesPerson column. In this model I'd like to give them roles, but there I have to create roles for 2 tables. I'd like that they can see both sheet filtered with their own SalesPerson code. Can I do this in one model?

Many thanks for the help in advance!

Mate

[v-cherch-msft]

Hi @Anonymous 

Here are some articles for your reference.

https://docs.microsoft.com/en-us/power-bi/service-admin-rls

https://radacad.com/row-level-security-configuration-in-power-bi-desktop

https://radacad.com/dynamic-row-level-security-with-manager-level-access-in-power-bi

Regards,