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 the Users.
2. Crated roles in SSAS and added users to membership.
And below picture for reference.
3. Used below DAX query to apply Dynamic RLS
=DimSalesTerritory[SalesTerritoryKey]=LOOKUPVALUE(DimUserSecurity[SalesTerritoryID], DimUserSecurity[UserName], USERNAME(), DimUserSecurity[SalesTerritoryID], DimSalesTerritory[SalesTerritoryKey])
4. Shared Power Bi report to the Users(Local AD users).
5. User can not able to see the content (User could see the blank visuals).
6. It is working for the Static RLS.
Given the DAX : =DimSalesTerritory[SalesTerritoryKey]=2
For more information I have On-Prem SSAS, Local AD users and live connection with the Power BI.
what would be the reason for this. If any suggestions , it would be appriciated.Thanks in Advance.
Solved! Go to Solution.
USERNAME() behaves differently on Desktop and Service. Always use USERPRINCIPALNAME() and always use email addresses, not domain accounts.
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?
Check out a full recap of the month!
Check out the winners of the recent 'Can You Solve These?' community challenge!
Join us for an in-depth look at the new Power BI features and capabilities at the free Microsoft Business Applications Launch Event.