How to use RLS on one page and NO RLS on the another page

Anonymous when you apply RLS data will automatically get filter according the Row level restrictions placed. You can't restict access to one page as RLS is applied on the dataset.

However, there are cases where we may need to overried RLS in such cases you can either create seperate tables if possible. Else best thing would be to create a measure that is not impacted by RLS.

below are some links can guide you in the right direction

https://community.powerbi.com/t5/Desktop/RLS-creating-a-measure-to-overide-RLS/td-p/37019

https://docs.microsoft.com/en-us/power-bi/guidance/rls-guidance#:~:text=While%20it's%20not%20possible%20for,constrained%20by%20any%20RLS%20filters.

Hi Anonymous 

I wonder if the data from page1 and page2 are related ? If it has relationships between different data, it will definitely be affected by filters .And as per the online document Row-level security, the RLS filter the dataset directly. 

If it possible , you can create a separate table in page1, without establishing any relationship, then you will not be affected by RLS.

More info about RLS can refer to the link :

https://docs.microsoft.com/en-us/power-bi/guidance/relationships-bidirectional-filtering

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

Best Regards

Community Support Team _ Ailsa Tao

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