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.

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
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()

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    There is no emailid field in accounta table, that is soo simple RLS, that doesn't work here.

     

    we need to virtually filter the accounts table data based on user login. User email and his accounts are in table 2. 

    kindly give me a solution. 

    • mwegener's avatar
      mwegener
      Icon for Most Valuable Professional rankMost 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.