Forum Discussion
Solved
Power BI Manage Roles - Single User Multiple Instances within the same Role
Hello All! I've got a problem when setting up roles where I was trying to base it on the User's email and what store's data they can see. I've looked around and can't seem to get an answer s...
hi VayunRangnekar ,
Have your tried creating a many to many relationship (role filtering store dimension) and then in the role set [Store] = USERPRINCIPALNAME()? I have the same setup in one of my clients. An account email may actually repeat several times as one can have multiple assigned territories.
danextian
Super User
Super Userhi VayunRangnekar ,
Have your tried creating a many to many relationship (role filtering store dimension) and then in the role set [Store] = USERPRINCIPALNAME()? I have the same setup in one of my clients. An account email may actually repeat several times as one can have multiple assigned territories.
Perfect! That has resolved the issue.
I didn't have the Many-To-Many relationship as you mentioned
