automate report access

The way orgs typically do this is via updating security groups in their automation, so for example they would have an onboarding PowerShell script that adds new users to a security group. That security group would be applied to various resources, including Power BI workspaces or reports, so anyone added to the group would get access. This is a normal IT function, I'm not sure if you're in IT or not but someone in your IT department is likely to be familiar with PowerShell. You could use Power Automate, too, but PowerShell is the typical go-to for onboarding. 

You should not do either for regular users - these should be given access to the app (by adding them to one of the app audiences. 

Best practice is to use distribution lists and then to use external tools to manage these PDLs, including onboarding, periodic auditing, and offboarding.

Hi powerbiexpert22 ,

You try this -Create SharePoint form and get user details and reason why they need access etc,...And you can power bi rest API commands and you build a power shell program to pass each users emails id recursively to that API call and provide required access or even you try power automate but it requires more knowledge and additional spending.

I hope it will be helpful.

Thanks,

Sai Teja