Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
Anonymous
Not applicable

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

Hi guys,

 

I have a complicated situation with RLS. I have 2 pages:

- Page 1 everyone can see all the data (Overview our department).

- In Page 2 the user is allowed to see only his data. (this is easy to fix namely Email = USERPRINCIPALENAME() )

 

But the thing is when I go to Page 1 then I see only the data of mine, but I need to see all the data of my department. How can I use 2 different RLS?

 

Is there any solution for this situation?

 

Thanks in advance!

2 ACCEPTED SOLUTIONS
negi007
Community Champion
Community Champion

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

 

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

View solution in original post

v-yetao1-msft
Community Support
Community Support

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.

View solution in original post

4 REPLIES 4
Anonymous
Not applicable

Sorry, but there is no clear reply!

Anonymous
Not applicable

Hi Guys,

 

Sorry for the late response! But the solutions to duplicate the datamodel does works thanks!

 

 

v-yetao1-msft
Community Support
Community Support

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.

negi007
Community Champion
Community Champion

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

 

 

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.