I have an azure group which is used to provide viewer access to the powerBI reporting.

The project is in such a way that the users that required permission to view this PowerBI will be changing on every week. Which means we have to clean and update the azure group every week.

I am having list of users with their emailID in a csv file which is updated on weekly basis.

I could try to add members using bulk operations in the portal, but since this is a continuous activity, I have to automate this process.
I tired automating from portal but it is only creating new groups based on the rules which we set.

Is there any way to achieve this ? Any leads appreciated.

Thanks in Advance!