how can i pass username from company website for row level security

[rajasekar_o]

I need more clarification 
one sales rep login  to company website now he want to see only His sales analysis  bi report 
how can i pass username from company website  for row level security 

[Idrissshatila]

Hello @rajasekar_o ,

you need to store the username in the power bi data, like in the sales rep dimension table where it is linked to the sales fact table.

[rajasekar_o]

how can i map the company website userid with userid table in power bi 

[Idrissshatila]

@rajasekar_o , this hsould be added as a column that would match the same id of the sales rep.

or create a seperate table that has the usernames from the web alongside the ones in the power bi.

[rajasekar_o]

am login my company website now i want to see my sales analysis report  how can i map with my userid with power bi row level security.