Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
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
Solved! Go to 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!
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!
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
User | Count |
---|---|
88 | |
85 | |
68 | |
66 | |
64 |
User | Count |
---|---|
208 | |
120 | |
113 | |
79 | |
72 |