cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samworth-andrea
Frequent Visitor

Limit HR Access by Divison/Department

I have a PowerBI document with HR data with a Company/Division/Department structure. I am able to export the security table for the HR program I'm using, which has various access rows. People might be granted access at two levels - for example the whole of company 1, but only division A, B and C for company 2. The information is linked to the active directory username. 

 

My appointments table has CompanyID, DIvisionID and DepartmentID for all staff. How do I use PowerBI to automatically limit someone's access based off of these tables?

1 ACCEPTED SOLUTION
selimovd
Super User
Super User

Hey @samworth-andrea ,

 

take a look at the roles and row level security:

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

You can create roles for each department and then in the Power BI Service you can map an AD group to a specific role. Like this you can limit the access.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

1 REPLY 1
selimovd
Super User
Super User

Hey @samworth-andrea ,

 

take a look at the roles and row level security:

Row-level security (RLS) with Power BI - Power BI | Microsoft Docs

 

You can create roles for each department and then in the Power BI Service you can map an AD group to a specific role. Like this you can limit the access.

 

If you need any help please let me know.
If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
 
Best regards
Denis
 

View solution in original post

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.