Automatically add new employees to AD group for access and RLS

[ck1995]

Hello

I have a tedious task that I would like to automate and need some suggestions.

For every report that I release, I am required to do the following

1. Add employees in excel that contains Branch Name & Email ids,

2. Add employee to an Active Directory group (group is auto-created as the company policy does not recommend adding all employees to all report AD groups)

3. In Power Bi service role if the data model fails to work if the same AD group is added to all Roles in RLS

Now that I am maintaining 6 reports, any new employee who gets added in the system or their role changes, I have to manually add them to all 6 AD groups, 6 excel files & if needed in the PBI role.

Can you please suggest how I can automate this without having to maintain multiple excels.

Excel is maintained because some reports have access only from a certain hierarchy.