Forum Discussion

nhintl19's avatar
nhintl19
Regular Visitor
7 years ago

Using row level security with multiple item columns

Hello,   I am needing to implement row level security that pulls an email/username from a sql server table column. The column can hold multiple usernames.   What I need is a DAX expression that l...
Need Help
nhintl19's avatar
nhintl19
Regular Visitor
7 years ago

Hello v-cherch-msft

 

While the first link does have some helpful information it would require some changes to our database. I would like to know if it is possible to implement RLS in a method that would function with my current setup first. If it is not possible to implement as I have described I will look into the first link further.

 

Thank you,

nhintl19

  • malv's avatar
    malv
    New Member
    3 years ago

    Hi!

     

    Have you ever found a solution for this one? I also have the same scenario, multiple emails in one column and they need to access the specific row they are listed on.

     

    The current solution I have is to edit the data itself in Power Query to split these email addresses to different columns.

     

    Appreciate if you could share a solution you found, if any.

    Thanks!