Using username() to obfuscate user information

[jamesom]

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.

[Nishantjain]

@jamesom 

have you tried using row level security?

Row Level Security - Power BI Embedded