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.

v-yalanwu-msft's avatar
v-yalanwu-msft
Icon for Community Support rankCommunity Support
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.