Forum Discussion
Solved
SSAS Tabular model Row Level Security is not working in Power BI Desktop
Hello - We have set up a SSAS Tabular Model and created 2 roles as below. 1. Admin - Administrator, Full Control 2. Employees - Read Only There are 2 users added as members in Employee...
It should work on both desktop and service this case.
Last test I can think about is, create the 2 measures I mentionned above, display it in desktop by these 2 users to see what they actually see.
check ou this blog to get better understanding about this test : https://www.kasperonbi.com/power-bi-desktop-dynamic-security-cheat-sheet/
I am have a similar problem and I can't get rls to work in ssas, excel or power bi. Below is the model:
Also, I have tried ='DimServer'[ServerKey]= LOOKUPVALUE( 'DimServerSecurity'[ServerKey], 'DimServerSecurity'[UserName], USERNAME() ) and ='DimUser'[UserName]=USERNAME()