Forum Discussion

lmhinson's avatar
lmhinson
Frequent Visitor
3 years ago

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, ...
Data Protection
Need Help
freginier's avatar
freginier
Solution Sage
3 years ago

import your data + user data 

create one RLS  'user date' [email] = USERPRINCIPALNAME()

link your data + user data and then your data will be filtered 

 

______________________________________________________

If you found this post helpful, please give Kudos C

  • lmhinson's avatar
    lmhinson
    Frequent Visitor
    3 years ago

    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's avatar
      freginier
      Solution Sage
      3 years ago

      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