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/
Helper IIIHello..
Yes we implemented Tabular model as suggested in this article. RLS works as expected when you publish and share reports with end users.
But it doesn't work when end user connects to Power BI Desktop and Tabular model on local machine. We don't see RLS applied for that user in Power BI Desktop.
Hope this clears my question.
Thanks!
Advocate II
You need to test it in Power BI Service. It will render the correct USERNAME.
You can create 2 measures, 1 = USERNAME() the other one = USERPRINCIPALNAME()
Then publish to the service, the result should be different.
- mittalpatel130
Leed - We already tested on Power BI Service and it works perfectly fine. Do you mean Tabular model RLS doesn't reflect in Power BI Desktop when User connects to it?
We are planning to rollout Tabular model as a solution and users will create report themselves in Power BI Desktop for their own department. It is necessary that they see their own data and not all departments' data.
- leed
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,
- mittalpatel130
Hi 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.