Forum Discussion
Dynamic Row level security
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 | [email protected] |
| John | User1 | [email protected] |
| Sarah | User2 | [email protected] |
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 ?
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.
2 Replies
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.
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.
