Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

Dynamic RLS

Hi, Say like 2 tables. 1 is fact with unique accounts and its transactions. 2 is accountid and email ids.   an account can be shared with multiple users, so table 2 will have many records.   F...
  • lbendlin's avatar
    lbendlin
    6 years ago

    Let the data model do the work.  Link the tables, make sure the filter direction is pointing from accounts to transactions, and put the RLS on the accounts table with a simple formula:

     

    [Emailid]=USERPRINCIPALNAME()

  • mwegener's avatar
    mwegener
    6 years ago

    Hi Anonymous ,

     

    it is as easy as described by lbendlin 

    You can find my example PBIX attached.

mwegener's avatar
mwegener
Most Valuable Professional
6 years ago

Hi Anonymous ,

 

it is as easy as described by lbendlin 

You can find my example PBIX attached.

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Thank you Marcus, well in my scenario, i have already used apply security check box to another, so i cant use it here. Give me sometime, i will test again and i will post my data model picture.