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/
Community SupportHi mittalpatel130 ,
You could refer to this document :
https://docs.microsoft.com/en-us/power-bi/desktop-tutorial-row-level-security-onprem-ssas-tabular
It details how to set up RLS in SSAS Tabular model.
mittalpatel130Hello..
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!
leedAdvocate 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.