Forum Discussion
Helper IIISSAS 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/
Advocate II
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
Helper IIIHello 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!
- leed
I see your screen shots. Which version of SSAS is that? I am using 2016 SSAS Tabular and dont see UserPrincipalName().
Do higher version of SSAS has this DAX function?
Thanks
Manoj
- leed
Hi Anonymous
This is a pretty basic DAX function, I think it's avaialable on all the version.
Whatever, below is the detail of my SSAS tabular server.
Best,