Forum Discussion
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...
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
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!