Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

RLS for Multiple emails in a same row to see same data

Hi 
i have multiple emails in a same row, need RLS for the beow requrirement

example- apple,car,banana, ornages should see same set of data as below screenshot
                Pen,train, shop ,food should see same data when they open PBI report individually or login individually

> i have email column in only one table (from souce also there  is one table only , no joins or no relationships )

 

2 Replies

  • weiqb's avatar
    weiqb
    Frequent Visitor

    hi,you can use find function.

     

  • Joe_Barry's avatar
    Joe_Barry
    Icon for Solution Sage rankSolution Sage

    Hi Anonymous 

     

    I use

    CONTAINSSTRING([Email], USERPRINCIPALNAME()) 

     

    Joe