Forum Discussion

LDevi86's avatar
LDevi86
Frequent Visitor
6 years ago
Solved

Dynamic Row Level Security for the live connection with SSAS Tabular Model

Hi All, I am implementing the Dynamic Row Level Security for the power bi users, which is live connection with SSAS tabular model.   I gone through the below steps: 1. I have created a table with...
Need Help
lbendlin's avatar
lbendlin
Super User
6 years ago

USERNAME() behaves differently on Desktop and Service. Always use USERPRINCIPALNAME() and always use email addresses, not domain accounts.

LDevi86's avatar
LDevi86
Frequent Visitor
6 years ago

Thanks for the reply. 

I have changed the table and DAX query as below using UPN.

And DAX :

=DimSalesTerritory[SalesTerritoryKey]=LOOKUPVALUE(DimUserSecurity[SalesTerritoryID], DimUserSecurity[UserName], USERPRINCIPALNAME(), DimUserSecurity[SalesTerritoryID], DimSalesTerritory[SalesTerritoryKey])

 

But the result is same, User could see blank report.

Do I should change the DAX query? any other settings to fix it?

 

Thanks,

Lakshmi

  • lbendlin's avatar
    lbendlin
    Super User
    6 years ago

    In power bi create a RLS role and for the DimUserSecurity table specif the rule

     

    [Username]=USERPRINCIPALNAME()