Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

dynamic RLS

hello I have this table with the accesses that each user must have. furthermore i created this rule, however with use the maxx is only the last value is returned example: [email protected] should h...
Need Help
  • v-deddai1-msft's avatar
    v-deddai1-msft
    6 years ago

    Hi Anonymous ,

     

    As the formula in the link you refer to you should create：

     

     

    Org Level 4 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 4)
)

Org Level 3 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 3)
)

Org Level 2 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 2)
)

Org Level 1 = LOOKUPVALUE (
    User[Email],
    User[Name],
    PATHITEM ( 'User'[Hierarchy], 1)
)

     

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

    Best Regards,

    Dedmon Dai

amitchandak's avatar
amitchandak
Super User
6 years ago

Anonymous ,

Try RLS

https://community.powerbi.com/t5/MBAS-Gallery/Microsoft-Power-BI-Unleash-row-level-security-patterns-in-Power/td-p/712613
https://radacad.com/dynamic-row-level-security-with-organizational-hierarchy-power-bi
https://www.blue-granite.com/blog/using-dynamic-row-level-security-with-organizational-hierarchies
https://docs.microsoft.com/en-us/power-bi/service-admin-rls
https://blog.tallan.com/2018/04/10/row-level-security-in-power-bi-part-1-roles-and-users/
https://radacad.com/what-do-you-need-to-implement-dynamic-row-level-security-in-power-bi

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    hi amitchandak 

    Thanks for your help but it didn't work.
    i followed this toturial https://radacad.com/dynamic-row-level-security-with-profiles-and-users-in-power-bi but it doesn't work because it doesn't use hierarchy.

    that is, user [email protected] must see all records. the user [email protected] should see everything below him (and himself) and the user [email protected] should only see himself.
    any idea how to do this?
    thank you very much

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago

        hi amitchandak 

        I've been following the tutorial. I do not want to give access by the number of employees but by the level of access. so I had to make some changes to the tuturial formula,
        as the LOOKUPVALUE function does not support comparisons between texts it is not possible to follow the toturial.
        thanks for your help.
        Any idea how to continue?

         

        formula in toturial:

         

        Org Level 4 = LOOKUPVALUE (
    'Organization'[Email - Work],
    'Organization'[Employee ID],
    PATHITEM ( 'Organization'[Organizational Hierarchy], 4, 1 )
)

        my formula:

        Org Level 4 = LOOKUPVALUE (
    User[Email],
    User[last nivel],
    PATHITEM ( 'User'[Hierarchy], 4, 1 )
)


last nivel = IF(User[Parent]="",User[Name],User[Name])