Forum Discussion

prajaktakeni11's avatar
prajaktakeni11
Helper I
2 years ago

RLS based on Category

Hello , I have employee data with different role , I want to restrict data based on Resource type for example Employee (1) has resource type A and is location head can view only his data being a lo...
Dynamic row level security
prajaktakeni11's avatar
prajaktakeni11
Helper I
2 years ago

I do have a Refrence Table , with USERNAME we are mapping it to Resource Type 

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    Needs to be USERPRINCIPALNAME.  their email address, basically.

    • prajaktakeni11's avatar
      prajaktakeni11
      Helper I
      2 years ago

      lbendlin  Can't we do it with employee id USERNAME()......?,
      and Could you please help me out on dax how can I restrict data based on Type for specific People

      • lbendlin's avatar
        lbendlin
        Super User
        2 years ago

        For dynamic RLS you don't need anything else, but it must use USERPRINCIPALNAME, and your reference table must control the fact tables of the data model.