Forum Discussion

Hussein_charif's avatar
Hussein_charif
Helper V
1 year ago
Solved

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 s...
Need Help
Show and Tell
Tips and Tricks
  • ThomasWeppler's avatar
    ThomasWeppler
    1 year ago

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

     



     

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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