Forum Discussion
Solved
Dynamic Row Level Security with multiple user tables
Hi, The logic is really escaping me on how I can deal with this issue and I can't find anything that is exactly the same so I'm hoping someone can help! I have a list of users for my Power BI...
Thanks for this! I was looking for some way around the many to many solution but I couldn't find one. To get around the need for two tables etc I just blew out my user table to have one line per "department" that I'm joining back to my main fact table on. This seems to work, I'd like to get around the many to many relationship but I'm not sure there is a solution!
Your RLS reference table should have a department column and a "See all" column. Then your RLS rule can be
[Department] = "xxx" || [See all]