Skip to main content
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Not applicable

RLS Power BI - FIlter Sales Representative



I need some help. I have a slicer with name of users. These users are sales representative, and i need to create a role to filter this users. For example, i have John, Mark and Peter. When John, for example, open the report, he can only see his name on the slicer. 


I only have a table with names, like John Walls, Mark Stones and Peter William, not a column with mails. 


But the names are a alias, and and the alias has an email associated with the tennant ad. I have to create a role, and use like: [sales_rep_name] = USERNAME(), and on power bi service i need to put all the names on this role? 

Thanks and best regards. 

Super User
Super User

That could work, maybe.


Alternatively, you could just create 3 roles like:


John Walls role:

[sales_rep_name] = "John Walls"


Mark Stones role:

[sales_rep_name] = "Mark Stones"


Peter William role:

[sales_rep_name] = "Peter William"


In the Service, assign each user to his/her role.

Follow on LinkedIn
@ me in replies or I'll lose your thread!!!
Instead of a Kudo, please vote for this idea
Become an expert!: Enterprise DNA
External Tools: MSHGQM
YouTube Channel!: Microsoft Hates Greg
Latest book!:
The Definitive Guide to Power Query (M)

DAX is easy, CALCULATE makes DAX hard...
Not applicable

Hi Greg,

Thanks for your reply. I know, but i have 86 usernames, that’s the problem :/. Do one by one, it's very exhausting.

Once again, thanks and best regards.

Helpful resources

July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.


Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors