Power BI Exchange

Please login or click SIGN UP FOR FREE to create your PowerBIUG account to join this user group.
Expand all | Collapse all

Issue with Security with multiple roles in same table

  • 1.  Issue with Security with multiple roles in same table

    Posted Mar 04, 2020 12:49 PM
    Hi All,

    I have security table as below.

    EmailID          dept
    xyz@a.com      10
    abc@y.com       20

    there are two roles

    role_dynamic  emailID=userprinciplename()
    role_dept_20  dept='20'

    when I am trying to add a common user to both the roles. I get conflict. Would be really helpful if any one has any solution or workaround.

    ------------------------------
    Harshal Biranwar
    BI Analyst

    ------------------------------
    Academy - Online Interactive Learning from Experts


  • 2.  RE: Issue with Security with multiple roles in same table

    Top Contributor
    Posted Mar 05, 2020 09:18 AM
    Please be more specific. There should not be a conflict. The more permissive rule will overpower the more restrictive rule.

    Also, it's USERPRINCIPALNAME() (spelling)

    ------------------------------
    Lutz
    ------------------------------

    Academy - Online Interactive Learning from Experts