Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Dynamic Row Based Security

I have been following THIS article on how to setup row based security using passed through credentials.   I have two identical (duplicates) tables: Employee, and EmployeeSecurity that consist of th...
DAX filter formula
PowerBi and SSRS Server
tabular
v-yulgu-msft's avatar
v-yulgu-msft
Microsoft Employee
8 years ago

Hi Anonymous,

 

According to above tutorial, your DAX filter formula should be:

 =Employee[SupervisorID]=LOOKUPVALUE(EmployeeSecurity[SupervisorID],EmployeeSecurity[ActiveDirectoryUserName],USERNAME(), EmployeeSecurity[SupervisorID], Employee[SupervisorID])

Regards,
Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Thanks for the response v-yulgu-msft.

     

    I'm wondering if the problem might be a few things together.  Possibly the created relationship with filter direction and a poor understanding of the LOOKUPVALUE DAX.

     

    With the changes you suggested the user received no data.  I altered the DAX to:

    =Employee[ContactID]=LOOKUPVALUE(EmployeeSecurity[ContactID],EmployeeSecurity[ActiveDirectoryUserName],USERNAME(), EmployeeSecurity[SupervisorID], Employee[SupervisorID])

    And now the user sees SOME data but not his/her own records.

     

    Does anyone have experiance with this, and if so do you have any documentation, examples I can look at?