Forum Discussion
Solved
Calculated Column using USERPRINCIPALNAME()
Hi All, I need to hide some sensitive column details (Eg: Name) based on logged in user. I cannot use USERPRINCIPALNAME() in a calculated column. I need to create a slicer on this sensitive c...
Take a look at the following blog to see if their solution maybe an option for you
https://sqldusty.com/2019/10/08/dynamic-column-level-security-with-power-bi-and-ssas/
Hi amitchandak I have to implement almost the same scenario mentioned above.. You stated following in the above post "The best you can do making that value as blank for a user using - USERPRICIPALNAME".
Can you please suggest steps for same. I tried it but as the UserPrinicipalName can be used only in measure, I a, not able to implement the dynamic Column security. Also the requirement is for both internal as well as external users. I have to show all columns to internal user but conditionally show few columns to an external user. Please suggest.