Quarterly audit for user access to Workspaces, Apps, dashboards, and reports.
I need to be able to audit who has access to workspaces, apps, reports, and dashboards on a quarterly basis. Is there a way to pull this information either via powershell or within Power BI itself? I can't use the azure audit logs since they only look at activity, not potential activity. I couldn't find a Powershell Cmdlet that pulls members of a workspace, or app. Please tell me this is feasable, I really don't feel like manually going through everything.
When I run this command I get the users: Get-PowerBIWorkspace -Scope Organization
However when I try to Get-PowerBIWorkspace -Scope Organization -top 50 | ConvertTo-Json the users all show up "as Microsoft.PowerBI.Common.Api.Workspaces.WorkspaceUser" Is there a way to just keep the users as a json?