Forum Discussion
Solved
SSAS Tabular model Row Level Security is not working in Power BI Desktop
Hello - We have set up a SSAS Tabular Model and created 2 roles as below. 1. Admin - Administrator, Full Control 2. Employees - Read Only There are 2 users added as members in Employee...
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/
Hi leed
Thanks for you response.
Your version is 14.0.6.443 - This is 2017 SQL Build Version
My version is 13.0.5201.2 - This is 2016 SQL Build version.
But compatability is 1200 which is supported from 2016.
So i need to conclude that in 2016 SSAS Tabular, userprincipalname() DAX function doesnt work, like said in many other forums.
Thanks
Manoj
Thank you for letting me know! Appreciate it!