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

View all the Fabric Data Days sessions on demand. View schedule

Reply
Odn_ndO
Helper I
Helper I

Role Level Security (RLS) advise and help

I have a report with many pages.

I would like everyone to be able to see the first page without applying RLS but in the 2nd page onwards, i would like to apply RLS.

How is it that i can apply different RLS to different pages?

 

How can i apply the roles to the respective pages in my report?

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi, @Odn_ndO 

According to your description, you want to realize that configuring different RLS on different pages, RLS will directly filter the dataset, and if the data of two pages are related, it will be affected by the filter.

Official Documentation link: Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

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

More information about RLS can be found at the following link:

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

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

 

Related Link: Solved: How to use RLS on one page and NO RLS on the anoth... - Microsoft Fabric Community

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

View solution in original post

1 REPLY 1
Anonymous
Not applicable

Hi, @Odn_ndO 

According to your description, you want to realize that configuring different RLS on different pages, RLS will directly filter the dataset, and if the data of two pages are related, it will be affected by the filter.

Official Documentation link: Row-level security (RLS) with Power BI - Power BI | Microsoft Learn

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

More information about RLS can be found at the following link:

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

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

 

Related Link: Solved: How to use RLS on one page and NO RLS on the anoth... - Microsoft Fabric Community

 

Best Regards,
Yang
Community Support Team

 

If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.
If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

How to get your questions answered quickly --  How to provide sample data in the Power BI Forum

Helpful resources

Announcements
November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 2025 Power BI update to learn about new features.

Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors