Forum Discussion

abhiram342's avatar
abhiram342
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago
Solved

Table level Security not working as expected

Hi Team,   I want to hide fact table , if user is not present in User Table. Please find example below User Alias [email protected] [email protected] Fact Sales DateId SalesAmount 20...
  • v-yanjiang-msft's avatar
    4 years ago

    Hi abhiram342 ,

    According to your description, I create a sample, and apply your code, got the opposite result you expected.

    The meaning of "NOT ISEMPTY(FILTER(VALUES(User),User[User Alias] = USERPRINCIPALNAME()))" is that user is in User Table, so you should remove NOT here, modify to:

    IF (
        ISEMPTY ( FILTER ( VALUES ( User ), User[Alias] = USERPRINCIPALNAME () ) ),
        FALSE (),
        TRUE ()
    )
    

    Get the correct result.

    I attach my sample below for reference.

     

    Best Regards,
    Community Support Team _ kalyj

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