Hello,
I am looking to write a PowerShell script that will retrieve all available information pertaining to Audiences in Power BI, including which reports are published to which audience, and which users or groups have viewing permissions to each audience.
When I asked Bing AI on Sunday, it happily returned this script:
# Load the Power BI module
Import-Module MicrosoftPowerBIMgmt
# Login to Power BI service
Login-PowerBI
# Get the workspace ID by name
$workspace = Get-PowerBIWorkspace -Name "My Workspace"
# Get the app ID by workspace ID
$app = Get-PowerBIApp -WorkspaceId $workspace.Id
# Get the audiences for the app
$audiences = Get-PowerBIAppAudience -AppId $app.Id
# Loop through each audience and get all available information for it
foreach ($audience in $audiences) {
Write-Host "Audience: $($audience.Name)"
Write-Host "ID: $($audience.Id)"
Write-Host "Description: $($audience.Description)"
Write-Host "Created By: $($audience.CreatedBy)"
Write-Host "Created On: $($audience.CreatedOn)"
Write-Host "Modified By: $($audience.ModifiedBy)"
Write-Host "Modified On: $($audience.ModifiedOn)"
Write-Host "Users or groups:"
$users = Get-PowerBIAppAudienceUser -AppId $app.Id -AudienceId $audience.Id
foreach ($user in $users) {
Write-Host "$($user.DisplayName) ($($user.EmailAddress))"
}
}
Two days later, this seems to have disappeared from Bing. The command Get-PowerBIAppAudience doesn't seem to exist anywhere on the Internet. Bing now recommends an imaginary URL about a non-existent Operation on the REST API page.
We have hundreds of workspaces in our tenant, each with or without an audience for its published reports. Retrieving this information manually is not a feasible solution.
Does there exist a cmdlet or script that will return the desired information?
