Forum Discussion

gracie494's avatar
gracie494
Helper I
1 year ago
Solved

Row Level Security - Condition based on UserPrincipleName

Trying to create a condition where if user access = 1, they can see all data in the table, if 0 then the access is assigned based on their security row. Below is the fomula but its not working:   ...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

    Hi gracie494 

    You can achieve your requirements by assigning different roles to relevant users in the workspace. For those who need to see all the data in the table, you can assign them any of the three roles other than Viewer. For those who need to be restricted by row-level security, you should assign them the Viewer role.

    Roles in workspaces in Power BI - Power BI | Microsoft Learn





    Best Regards,

    Jayleny

     

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

Anonymous's avatar
Anonymous
Not applicable
1 year ago

Hi gracie494 

You can achieve your requirements by assigning different roles to relevant users in the workspace. For those who need to see all the data in the table, you can assign them any of the three roles other than Viewer. For those who need to be restricted by row-level security, you should assign them the Viewer role.

Roles in workspaces in Power BI - Power BI | Microsoft Learn





Best Regards,

Jayleny

 

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