Forum Discussion
Userprincipalname if statement
Hi jlee724
One method is to use Row-level security to mask all names but that of the current user.
See this Medium post for something similar.
As an example, I've attached a PBIX.
Model diagram:
The Salesperson table (filtered using RLS on User = [email protected]😞
The RLS filter is on the Salesperson table:
When [email protected] is the current user, all other Salespeople appear as "X":
Hi jlee724
One method is to use Row-level security to mask all names but that of the current user.
See this Medium post for something similar.
As an example, I've attached a PBIX.
Model diagram:
The Salesperson table (filtered using RLS on User = [email protected]😞
The RLS filter is on the Salesperson table:
When [email protected] is the current user, all other Salespeople appear as "X":