Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 ...
data protection
Need Help
Tips and Tricks
  • v-yalanwu-msft's avatar
    v-yalanwu-msft
    4 years ago

    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's avatar
croberts21
Icon for Continued Contributor rankContinued Contributor
4 years ago

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.