https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1938825#M20011 <P>You would create 2 roles, one with the RLS rule and one with no restrictions. Then you just add the relevant people/groups to the relevant role (making sure that a given user is only in one of the two roles)</P> Tue, 06 Jul 2021 00:58:16 GMT d_gosbell 2021-07-06T00:58:16Z https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1937839#M20003 <P>Hi guys,</P><P>I want to ask about your advice regarding using row level secutiy option. I have many users (around 4000)&nbsp; that should see only their own information (and I used row level security level) , but also a big group of people (around 2000)&nbsp; that should see everything. Is is possible to have it on one dahsboard? If, yes how this should be applied?&nbsp;</P><P>&nbsp;</P><P>Thanks,</P><P>Asia</P> Mon, 05 Jul 2021 10:12:17 GMT https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1937839#M20003 joannasokolowsk 2021-07-05T10:12:17Z https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1938825#M20011 <P>You would create 2 roles, one with the RLS rule and one with no restrictions. Then you just add the relevant people/groups to the relevant role (making sure that a given user is only in one of the two roles)</P> Tue, 06 Jul 2021 00:58:16 GMT https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1938825#M20011 d_gosbell 2021-07-06T00:58:16Z https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1939961#M20022 <P>Perfect! thank you for the help!</P><P>&nbsp;</P><P>Asia</P> Tue, 06 Jul 2021 11:17:47 GMT https://community.fabric.microsoft.com/t5/Report-Server/Row-level-security-on-power-bi-reporting-server/m-p/1939961#M20022 joannasokolowsk 2021-07-06T11:17:47Z