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 location head and related resource data fromsales  table 

can you please help 

 

Dynamic row level security

7 Replies

  • lbendlin's avatar
    lbendlin
    Super User
    2 years ago

    I assume you have a reference table in your data model that maps USERPRINCIPALNAME 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