Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!
I've got a HR dashboard with a working security setup, based on a number of departments and department IDs. My access table works, and I've created a role called DepartmentViewer, based on an email and security table which is stored in my HR application.
I want every user to have to go through the role, but I don't want to have to add everyone's email addresses manually to the Power BI service. Can I ensure that this role is set as some sort of "default"?
Solved! Go to Solution.
@Anonymous
You can add groups to the security role.
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
@Anonymous
You can add groups to the security role.
Row-level security (RLS) with Power BI - Power BI | Microsoft Docs
Paul Zheng _ Community Support Team
If this post helps, please Accept it as the solution to help the other members find it more quickly.
Use Distribution lists for role memberships.
| User | Count |
|---|---|
| 50 | |
| 43 | |
| 36 | |
| 33 | |
| 29 |
| User | Count |
|---|---|
| 139 | |
| 129 | |
| 61 | |
| 59 | |
| 57 |