Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I was wondering what is the best way to implement security and permissions in my company.
I have created a workspace for a sector in my company,
In this sector there is 3 areas and 40 branches.
There is a sector manager, 3 area manager, 40 branch managers and 200 users.
Sector manager should be able to see all 3 areas and all branches.
Area manager should be able to see 1 area and its branches.
branch manager only his branch and each user only his branch.
so my solution is to create rls and use username.
then in workspace i must add all this 250 users one by one?
Solved! Go to Solution.
@giorgiokatr How you break up and utilize workspaces would be up to you, but I typically use them for only the report authors. The users, you can just share dashboards with them and the Row Level Security that you set up on your model/report will work as expected. In this scenario, you can share the dashboard with 1 AAD security group that contains those users and everything just works without you managing permissions in Power BI.
@giorgiokatr How you break up and utilize workspaces would be up to you, but I typically use them for only the report authors. The users, you can just share dashboards with them and the Row Level Security that you set up on your model/report will work as expected. In this scenario, you can share the dashboard with 1 AAD security group that contains those users and everything just works without you managing permissions in Power BI.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
95 | |
46 | |
26 | |
21 | |
19 |