Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

Reply

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:
Screenshot 2024-10-30 095104.png

 

 

 

 

 

 

 

 

 

 

 

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?

 

 

1 ACCEPTED SOLUTION
ThomasWeppler
Impactful Individual
Impactful Individual

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. 

ThomasWeppler_0-1730279544243.pngThomasWeppler_1-1730279551437.png

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. 🙂
 

 



 

View solution in original post

3 REPLIES 3
v-xuxinyi-msft
Community Support
Community Support

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
Impactful Individual
Impactful Individual

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. 

ThomasWeppler_0-1730279544243.pngThomasWeppler_1-1730279551437.png

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
Super User
Super User

@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

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Helpful resources

Announcements
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

Find out what's new and trending in the Fabric Community.