\<< [[§ Power BI]]
---
# TL;DR
Usually implementing RLS in Power BI involves creating roles and assigning them to users or directory groups. This can be hard to maintain in case there are a lot of users and a lot of departments.
Using Dynamic Row Level Security, you combine DAX functions like USERID() to check what user is accessing the report and keep the user mapping logic somewhere else, like an excel or database table.
---
# References
- https://www.youtube.com/watch?v=jphj40tBPD8
- https://learn.microsoft.com/en-us/fabric/security/service-admin-row-level-security