Advanced Access Management in Power BI

Hello Everyone,

I have one problem and I can not find any good solution. I have 30 different organizations, each organization has about eight identical departments. It is necessary to provide each department with a separate access to each organization.

Creating 240 separate roles is a terrible decision and it's impossible to administer. It is possible to bind groups through the Active Directory for each user and get the attributes of organization and department. please provide a solution to facilitate access control.

I would like to create something like a matrix with 30 groups of organization access that intersect with 8 departments, but I do not know how it can be implemented in the AD.

I would be very grateful for the help :)