Forum Discussion

OlivierL972's avatar
OlivierL972
New Member
1 year ago
Solved

User name

Hello I share a Power BI report on Teams. I have defined rulls in my report to limite access according to the person who use the report. I would like to calculate the name of the person who has ope...
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi OlivierL972 

     

    Thank you very much rajendraongole1 for your prompt reply. Allow me to add something.

     

    Here are some specific steps to help you set up row-level security (RLS) in Power BI:

     

    Here's some dummy data

     

    “Name“

     

    "Sales"

     

    1.
    Modeling -> Manage roles

     

    2.

     

     

    [email] ==  userprincipalname()

     

    3.

    After setting up the RLS, publish the report to the Power BI service. In Power BI Services, go to the Settings page for the dataset and select Security.

     

     

    4.

    Share the report to teams.

     

     

    Here is the result.

     

     

    Row-level security (RLS) with Power BI - Microsoft Fabric | Microsoft Learn

     

    Regards,

    Nono Chen

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.