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

[imagautham]

In one of my reports in my organization, I could see that they have applied static RLS on one table (Example: [org]='ABC') and in another table they have applied dynamic RLS (Example: [Email]=USERPRINCIPALNAME()  ).

Is this possible?If yes, If an user is viewing the report, Whether will it check the static RLS or dynamic RLS?

[Anonymous · Accepted solution]

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-limi...

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

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.