Row level security_

[rajasekar_o]

HI TEAME,
I need help
i want to set Row level security  for BM ,RM ,FULL ACCESS
I HAVE table 

ASM	AREA	GROUP	BMID	BM EMAIL	RM ID	RM EMAIL
RAM	CHENNAI	TN	BM001	CHBM@GMAIL.COM
KUMAR	MADURAI	TN	BM002	MDUBM@GMAIL.COM	RM001	RMN@GMAIL.COM
VINOTH	SELAM	TN	BM003	SABM@GMAIL.COM	RM001	RMN@GMAIL.COM
VISU	MYSURU	KA	BM004	BMMSY@GMAIL.COM	RM002	RMK@GMAIL.COM
RAM	KAVERI	KA	BM005	BMKV@GMAIL.COM	RM002	RMK@GMAIL.COM
SELVI	BANGALURU	KA	BM005	BMKV@GMAIL.COM	RM002	RMK@GMAIL.COM

FULL ACCES USER

NAME	USERID	ACCES TYPE	AREA
KALAI	KALAI@MAIL.COM	FULL ACCESS	CHENNAI
KALAI	KALAI@MAIL.COM	FULL ACCESS	MADURAI
KALAI	KALAI@MAIL.COM	FULL ACCESS	SELAM
KALAI	KALAI@MAIL.COM	FULL ACCESS	MYSURU
KALAI	KALAI@MAIL.COM	FULL ACCESS	KAVERI
KALAI	KALAI@MAIL.COM	FULL ACCESS	BANGALURU
SONU	SONU@GMAIL.COM	FULL ACCESS	CHENNAI
SONU	SONU@GMAIL.COM	FULL ACCESS	MADURAI
SONU	SONU@GMAIL.COM	FULL ACCESS	SELAM
SONU	SONU@GMAIL.COM	FULL ACCESS	MYSURU
SONU	SONU@GMAIL.COM	FULL ACCESS	KAVERI
SONU	SONU@GMAIL.COM	FULL ACCESS	BANGALURU

SALES DATA 

ASM	SALES
RAM	145982
KUMAR	23542
VINOTH	234234
VISU	2354
RAM	34223
SELVI	23452

BM NEED NEED TO ACCES THER DATA ONLY
RM NEED TO ACCESS RELATED BM SALES DATA
FULL ACCESS USER NEED ACCES RELATED AREA SALES  

[Anonymous · Accepted solution]

Hi @rajasekar_o ,

Please follow these steps:

1. Define roles in Power BI Desktop:

Navigate to the Modeling tab and select Manage Roles.

Create three roles: BM, RM, and Full Access.

For the BM role:

For the RM role:

For full access, filters are not needed as they should allow access to all data.

If you don't want to see the entire contents of the table, enter the following expression.

2. Assign users to roles in the Power BI service:

After publishing the report to Power BI Service, go to Dataset Settings.

Under Security, assign users to the roles you defined based on their email addresses.

3. Test RLS:

In Power BI Desktop, use the View as Role feature to test by simulating different roles.

For more details please see:

Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

Row-level security (RLS) guidance in Power BI Desktop - Power BI | Microsoft Learn

The pbix file is attached.

If you have any other questions please feel free to contact me.

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!