Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

HOW TO EXCLUDE USER FROM RLS

samiply I need to exclude the Super End user from RLS Rols, in order to disply all data to him. IF UPPER(USERNAME()) <> "[email protected]" THEN [Emp_ID] = USERNAME() END IF; ALSO TRIED: IF UPPE...
Need Help
Icey's avatar
Icey
Community Support
6 years ago

Hi Anonymous ,

You can refer to this article.

My test results are as follows:

1. Two tables:

'Is Super End User' is a measure crested like so:

Is Super End User =
IF ( MAX ( Sales[SalesPerson] ) = "A", 1, 0 )

2. Manage Roles:

IF (
    MAXX ( FILTER ( 'Email', 'Email'[Email] = USERNAME () ), [Is Super End User] ) = 0,
    Email[Email] = USERNAME (),
    1 = 1
)

3. Result for SalesPerson A,

Result for SalesPerson C,

Best Regards,

Icey Zhang

 

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
6 years ago

Thanks for the great explination, Icey 

BUT , the USER is not included on data ....

this user : [email protected] 
Doesn`t have any records in AGTREF_DIM_RLS table

kindly advice

 

  • Icey's avatar
    Icey
    Community Support
    6 years ago

    Hi Anonymous ,

    1. You can create another two tables - 'User' and 'Access' or just one table. 

    2. Create relationships among them.

    3. Manage Roles:

    IF (
    MAXX (
        FILTER ( 'User', 'User'[Email] = USERNAME () ),
        RELATED ( 'Access'[Access] )
    ) = "Personal Data",
    User[Email] = USERNAME (),
    "ALL Data" = "All Data"
)

    4. Publish to Power BI Service and Manage security on the model.

    5. The result for User C:

    The result for User D:

    Best Regards,

    Icey

     

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