Forum Discussion

abhiram342's avatar
abhiram342
Microsoft 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

DateIdSalesAmount
20220101100

Implementation:

I have used tabular Editor and selected Fact Sales and Updated Object level Security to None

Roles:

I went to manage roles and created role with below dax code

RoleName: HideFactSales

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

Testing in local:

Consider my alias as [email protected]

I have selected role as HideFactSales but table is hidden for me. I expect the FactSales to show because I'm valid user

Please let me if I'm missing anything.

 

I have published report to PowerBI Service and added my alias to Security section but it shows same behaviour. Please assist

 

Note: I  have been assigned as contributor role to workspace.

 

Thanks,

Abhiram

 

DAX
Need Help
Need Help DAX
Row Level Security
  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    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.

     

1 Reply

  • v-yanjiang-msft's avatar
    v-yanjiang-msft
    Community Support
    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.