automate report access

[powerbiexpert22]

can it be possible to automate report access? example, i want to automate the process of adding user on to workspace or report 

[Anonymous · Accepted solution]

Hi @powerbiexpert22 ,

You can assign access by group and then automatically add members to the group through PowerAutomate.

The action of adding member to group in Power Automate.

Best regards,

Mengmeng Li

[christinepayton]

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. 

[lbendlin]

Err, no.  Powershell may work for small companies.  Enterprises use professional UAM (user access management) tools.

[SaiTejaTalasila]

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 

[lbendlin]

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.