Row level security

[Hussein_charif]

hello, i want to apply row level security for a power bi report. here is a sample table of each user and their access:

i also have a table in my model called salesteam, that contains a column for the salesteam name and a coumn for the user name, and another table called customers, that contains a column for the user name and a column for the company name.

how should i implement the row level security and the steps that i should do first?

[Anonymous]

Hi @Hussein_charif 

Thanks for the reply from amitchandak and ThomasWeppler .

Did the solution they provided solve your problem? If there is an answer that helped you, please accept it as a solution. This will be of great help to other users who have the similar problem as you.

If your problem is still not solved, please provide sample data of the table you want to use so that we can better help you. How to provide sample data in the Power BI Forum - Microsoft Fabric Community Or show them as screenshots or pbix. Please remove any sensitive data in advance. If uploading pbix files please do not log into your account.

Best Regards,
Yulia Xu

[ThomasWeppler · Accepted solution]

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 security

And place the users in the correct security group.

I hope this helped you solve your problem. 🙂

[amitchandak]

@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