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 service and desktop should show you the same result.
RLS does reflect in Power BI destkop, but if you open from desktop, the user instead being [email protected] they will be an AD user like US\xxx
Thats the reason you need to show up the 2 measures USERNAME() and USERPRINCIPALNAME() to see the difference between them then decide which one to use in SSAS TAB RLS.
Best,
Helper IIIHi leed
I got it what you mean.
Here is the screen print of my DAX filter and I don't think so I can add USERPRINCIPALNAME() here.
- leed
- mittalpatel130
- leed
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/