Forum Discussion

jamesom's avatar
jamesom
Regular Visitor
6 years ago

Using username() to obfuscate user information

Hi,

 

We provide client-facing embedded PBI reports on our cloud platform.

We have recently added Role-Based Access control to our platform, and the call to the embedded report passes a switch code and can be accessed within the report through username()

I need to obfuscate user data based on the username() value.

 

What I would like to be able to do is......

Column = if(username() = "A", "Obfuscate Data", [Name])

This would obfuscate all [names] for the given list. Measure only gives an aggregate.

 

Any help would be really appreciated.

Thank You.