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

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 ?

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

      There is no DAX filter, this is all controlled via the data model.