Forum Discussion
Row level security
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?
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. 🙂
3 Replies
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
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. 🙂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
