RLS setting Question

Question

How to create a report with RLS control and a report that is not restricted by RLS in a pbix file without copying a fact table (because the fact table is too big and I don't want to copy it)?

rajendraongole1 · Answer

Hi&nbsp;Anonymous&nbsp; -&nbsp;To create a report in Power BI with Row-Level Security (RLS) control and another report without RLS restrictions within the same PBIX file, without duplicating the fact table, you can use measures and filters creatively.&nbsp;
&nbsp;
attached the detailed steps, please follow and also sharing some resource please check
The Solution You Need for Dynamic Row Level Security: Semantic Model for User Access Table | by Avishek Ghosh (AV_DEVS) | Microsoft Power BI | Medium
Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn
&nbsp;
&nbsp;
&nbsp;

anonymous · Answer

Hi&nbsp;rajendraongole1&nbsp;,&nbsp;Check out&nbsp;Solved: How to use RLS on one page and NO RLS on the anoth... - Microsoft Fabric Community&nbsp;if it hleps.&nbsp;Cheers&nbsp;ChenuSing

rajendraongole1 · Answer

Hi&nbsp;Anonymous&nbsp; -&nbsp;You're absolutely right to aim for a solution that avoids duplicating the fact table and keeps the file size manageable.&nbsp;
Instead of relying on separate tables for restricted and unrestricted data, you can use DAX measures to dynamically control data visibility based on a toggle (eg. , slicer or parameters)
&nbsp;
I hope this details helps. Thank you

anonymous · Answer

Thanks for your answer, this solution seems to inevitably copy the fact table, which will cause the file to remain very large❤️

anonymous · Answer

Hi&nbsp;Anonymous&nbsp;,
&nbsp;
According to your statement, I think your requirement is to create a report with two pages one is under RLS control and another is not.
As far as I know, if you add RLS in your data model, users in&nbsp;each role can see the corresponding data.&nbsp;
For example, if UserA in role1, then UserA could only see that RLS restricts the data that role1 can see. We couldn't let UserA see all data without RLS at the same time.
So create a new report without rls or add a duplicate fact table may be the workaround.
If you want to restrict specific people to see data and some other people could see all data, you can try to user UERPRINCIPALNAME() to configure dynamic RLS.
Dynamic Row Level Security with Power BI Made Simple - RADACAD
&nbsp;
Best Regards,Rico Zhou
&nbsp;
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Forum Discussion

RLS setting Question

5 Replies

Related content

RLS Question

RLS question

Bookmark questions

Another RLS question - default roles

set up RLS for a security group in Power BI