Forum Discussion
lmhinson
3 years agoFrequent Visitor
Dynamic Row Level Security data setup and questions
Hi all. I'm building a report with multiple levels of managers (rep, district manager, regional managers, sales director) needing access to only their data. Sales director would see whole group, ...
lmhinson
3 years agoFrequent Visitor
freginier In this scenario, you are saying that all user data would have to be in one dimension table, and all email addresses would have to be in the same column within that table (as opposed to split how I have it now, with org structure built out through different columns)?
How would you handle org structure in that case?
Thanks!
freginier
3 years agoSolution Sage
Yes you need to add file with all users something like : email , Role (director, manager, etc.)
Maybe I can help you anymore if you send your power bi without sensitive data