Can Static and Dynamic Row Level security be applied in the same report?

Hi  imagautham ,

When using both RLS at the same time, the following error occurs:

The user belongs to multiple roles 'Sta role, da role' that have security filters, which isn't supported when one of the roles has filters affecting table 'Table' with SecurityFilteringBehavior=Both relationships.

You can refer to the following link to solve:

https://docs.microsoft.com/en-us/power-bi/enterprise/service-admin-rls#issue-multiple-roles-and-limited-relationships

https://community.powerbi.com/t5/Desktop/Users-with-multiple-security-roles-suddenly-can-t-see-data/td-p/2250567

Application Scenarios of Static RLS and Dynamic RLS

https://www.phdata.io/blog/power-bi-row-level-security/

https://hevodata.com/learn/power-bi-row-level-security/

Best Regards,

Liu Yang

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