Forum Discussion
Can Static and Dynamic Row Level security be applied in the same report?
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?
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:
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.
1 Reply
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:
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.