Forum Discussion
Row level security
Hi Hussein_charif
The first step is to add an e-mail to your table. This e-mail should contain the e-mail each user use to login to the powerBI service.
When that is done you need to create a role. You do that here.Create one role for each group that need its own logic.
Pick the table and write this logic. email is a placeholder for the name of the colum with the users e-mail.
[email] = userprincipalname()Next step is to go to the workspace in the powerBi service where your repport is uploaded to. pick securityAnd place the users in the correct security group.I hope this helped you solve your problem. 🙂
Hussein_charif , In power query split the column by delimiters into rows, so that on row will have one company
Power Query Split Column , Split Column By Delimiter: https://youtu.be/FyO9Vmhcfag
Then use this RLS with all. Please make sure One user should have all comapnies by name (not all). or all comapny values should be there in RLS table
Power BI- Row Level Security(RLS): Handle ALL, UserPrincipalName: https://youtu.be/KVLEnIUo4pc