Skip to main content
cancel
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

Reply
Anonymous
Not applicable

RLS Power BI - FIlter Sales Representative

Hi, 

 

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. 

2 REPLIES 2
Greg_Deckler
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...
Anonymous
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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors