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	[email protected]
KUMAR	MADURAI	TN	BM002	[email protected]	RM001	[email protected]
VINOTH	SELAM	TN	BM003	[email protected]	RM001	[email protected]
VISU	MYSURU	KA	BM004	[email protected]	RM002	[email protected]
RAM	KAVERI	KA	BM005	[email protected]	RM002	[email protected]
SELVI	BANGALURU	KA	BM005	[email protected]	RM002	[email protected]

FULL ACCES USER

NAME	USERID	ACCES TYPE	AREA
KALAI	[email protected]	FULL ACCESS	CHENNAI
KALAI	[email protected]	FULL ACCESS	MADURAI
KALAI	[email protected]	FULL ACCESS	SELAM
KALAI	[email protected]	FULL ACCESS	MYSURU
KALAI	[email protected]	FULL ACCESS	KAVERI
KALAI	[email protected]	FULL ACCESS	BANGALURU
SONU	[email protected]	FULL ACCESS	CHENNAI
SONU	[email protected]	FULL ACCESS	MADURAI
SONU	[email protected]	FULL ACCESS	SELAM
SONU	[email protected]	FULL ACCESS	MYSURU
SONU	[email protected]	FULL ACCESS	KAVERI
SONU	[email protected]	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!