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
Icon for Super User rankSuper 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