Forum Discussion
SSAS Tabular model Row Level Security is not working in Power BI Desktop
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/
Hello Leed -
Thank you for your response.
Can you please brief me on how to test with USERPRINCIPAL()?
Thanks!
The same way you did with USERNAME(), you just needed to replace the last one by USERPRINCIPALNAME().
On Power BI Service, unfortunately, if you pass by Live connection, you need to have a real user for the test, you cannot use RLS.
Best,
DA
Hello Leed,
I'm using simple Row level security with a filter condition on tables.. like Country = 'US' ..
It is not a dynamic security. Still your comments apply to it? I'm little confused on where to add that USERPRINCIPALNAME()? On DAX filters or in members of the Role?
Thank you very much for your response!