Dynamic Row level security

[Anonymous]

i want to give access to dashboard from excel file.. like if i add 80 emails to worksapce this is impossible to add 1 by 1 .. so i have a excel file like this 

SalesPerson	Designation	Email address
David	Manager	david2004@abc.com
John	User1	john12@abc.com
Sarah	User2	sarah@abc.com

and the list goes on 

i want to give access on the designation bases. if i give access User1 then all email address related to user1 should see sepecifc graphs and all rights of Users2

if i give access to Manager then he must be able to see all things realted to User1 and User2

but User2 not able to see all things in dashbord. he should see specifc data .. 

how i do this ?

[v-yalanwu-msft · Accepted solution]

Hi, @Anonymous ;
For implementing row level security in this scenario, one of the most common ways is using Path functions in DAX. Path functions are powerful functions that can navigate through an unknown level of hierarchy based on an ID, and Parent ID structure.
You should multiple columns(e.g.: [Common Manager], [Grand Manager]). For more info or details, refer to this blog:

Dynamic Row Level Security with Organizational Hierarchy Power BI - RADACAD

Best Regards,
Community Support Team _ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[croberts21]

You are talking about "roles". The higher roles get all the features of the lower roles plus more. 

PBI cannot even save a custom background color for different tabs on a report. And Microsoft has quite a backlog of issues. The issues they do are based on votes in the issues forum here: https://community.powerbi.com/t5/Issues/idb-p/Issues

The Issues forum is for bugs. The Ideas forum is a little different. Please search for your idea in the Issues forum first and use different keywords like: roles, inherited security, inherited roles, etc. Be creative. There isn't really a standard name to call this feature that I know of.