Calculated Column using USERPRINCIPALNAME()

[ArunTiruveedula]

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 column and creating a measure is not an option.

Is there a way to manipulate column data based on USERPRICIPALNAME. (Column level security)

[NayakShridevi]

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. 

[v-diye-msft]

Hi @ArunTiruveedula 

If you have solved your problem, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

[blopez11 · Accepted solution]

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/

[amitchandak]

@ArunTiruveedula , I doubt that is possible - refer -https://blog.pragmaticworks.com/row-column-and-table-level-security-in-power-bi

The best you can do making that value as blank for a user using - USERPRICIPALNAME