Filter Selections based on userprincipalname

[Anonymous]

Hi

I've a slicer that has selection of departments. So, I want to limit selection of departments based on the user logging in.

User	Department
user1@company.com	Marketing
user2@company.com	Sales
user3@company.com	Call Center

so if the user logging in was user2@company.com, then the user should see in the slicer ONLY Sales.

thanks in Advance

[Anonymous · Accepted solution]

Hi @Anonymous,

I'd like to suggest you refer to Gilbert's blog to know how to use RLS with username, then you can simply create a dynamic role based on the username and it will be interacting with the current user.

Power BI – Dynamic Row Level Security – Things you need to know to get it working! – Gilbert Quevauvilliers – BI blog (wordpress.com)
Regards,

Xiaoxin Sheng

[amitchandak]

@Anonymous , Create a role

[User] = userprincipalname()

make sure this table is joined with sales. 

How to use Row Level Security (RLS): https://youtu.be/NfdIA0uS6Nk