Forum Discussion

prajaktakeni11's avatar
prajaktakeni11
Icon for Helper I rankHelper 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
Icon for Helper I rankHelper I
2 years ago

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

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

Needs to be USERPRINCIPALNAME.  their email address, basically.

  • prajaktakeni11's avatar
    prajaktakeni11
    Icon for Helper I rankHelper 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
      Icon for Super User rankSuper 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.

      • prajaktakeni11's avatar
        prajaktakeni11
        Icon for Helper I rankHelper I
        2 years ago

        Okay and what would be my dax to filter the data as per specific category ?