Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 months ago
Solved

Role level Security for Group Alternate Access

Employee Name Requester-Approver Email Lookup Approver Group  Lookup Requester Group  Department Dept Invoice Number Aida  [email protected] 1   D A 13 Richard [email protected] 1   Q B...
Need Help
  • Mauro89's avatar
    Mauro89
    9 months ago

    Hi Anonymous,

     

    if I got it right, this should work. 

     

    1. Create a single GroupKey column

     

    In Power Query or DAX (calculated column):

    GroupKey =

    IF(

        NOT ISBLANK([Lookup Approver Group]),

        [Lookup Approver Group],

        [Lookup Requester Group]

    )

    Jay will have GroupKey = BLANK(), which is desired.

     

    2. Create an RLS role

     

    Use this DAX filter expression:

    [GroupKey] = 

        CALCULATE(

            MAX('Table'[GroupKey]),

            'Table'[Employee Name] = USERPRINCIPALNAME()

        )

     

    If this works, leave kudos or mark it as solution. 

    Best regards!

Mauro89's avatar
Mauro89
Icon for Super User rankSuper User
9 months ago

Hi Anonymous,

 

if I got it right, this should work. 

 

1. Create a single GroupKey column

 

In Power Query or DAX (calculated column):

GroupKey =

IF(

    NOT ISBLANK([Lookup Approver Group]),

    [Lookup Approver Group],

    [Lookup Requester Group]

)

Jay will have GroupKey = BLANK(), which is desired.

 

2. Create an RLS role

 

Use this DAX filter expression:

[GroupKey] = 

    CALCULATE(

        MAX('Table'[GroupKey]),

        'Table'[Employee Name] = USERPRINCIPALNAME()

    )

 

If this works, leave kudos or mark it as solution. 

Best regards!

v-achippa's avatar
v-achippa
Icon for Community Support rankCommunity Support
9 months ago

Hi Anonymous,

 

Thank you for reaching out to Microsoft Fabric Community.

 

Thank you Mauro89 for the prompt response. 

 

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user for the issue worked? or let us know if you need any further assistance.

 

Thanks and regards,

Anjan Kumar Chippa

  • v-achippa's avatar
    v-achippa
    Icon for Community Support rankCommunity Support
    9 months ago

    Hi @arikofather,

     

    Thank you Rufyda for the prompt response. 

     

    We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

     

    Thanks and regards,

    Anjan Kumar Chippa