Forum Discussion
RashmitaR
9 years agoHelper IV
RLS using common user id
Hi , I am trying to create a report User_id Email id Project Id value 1 [email protected] P_001 1000 2 [email protected] P_002 20000 3 [email protected] P_003 20000 4 [email protected] P_00...
Anonymous
9 years agoNot applicable
Hi RashmitaR,
In your scenario, it is not possible to create a role to make each user to view his respective project value. When you make use of USERNAME() function within your dataset, Power BI will automatically filter the data depending on the username used to login to Power BI service account.
In other words, as the users log into Power BI Service using email id, they always get two project values. You would need to ensure that they use different email id to log into Power BI.
Thanks,
Lydia Zhang