Row Level Security - Condition based on UserPrincipleName

[gracie494]

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:

if( LOOKUPVALUE('Auth Data Tables'[All Access],'Auth Data Tables'[Email],USERPRINCIPALNAME()

)

=1,

TRUE(),

'Auth Data Tables'[Email] = USERPRINCIPALNAME()

)

[Anonymous · Accepted solution]

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.

[gracie494]

does not work, 

[Kedar_Pande]

FilteredData = 
IF(
SELECTEDVALUE(UserTable[User Access]) = 1,
1, // If access is 1, show all data
IF(
COUNTROWS(
FILTER(
SecurityTable,
SecurityTable[UserID] = USERPRINCIPALNAME() // Assuming UserID matches with the user's email or ID
)
) > 0,
1, // If user has access based on security row, show data
0 // Otherwise, restrict access
)
)

add this measure to your visual-level filters.
Set the filter condition to show items when FilteredData equals 1.