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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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.


@ 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!:
Mastering Power BI 2nd Edition

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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