I finally got my powershell script working to call the Power BI rest methods to extract all workspaces and reports in workspaces.
But What I am missing is the the endorsement labels for each report. Does anyone know how I can modify this script get that info?
Any help would be appreicated.
# need to set this to ensure proper connections
[Net.ServicePointManager]::SecurityProtocol = [Net.SecurityProtocolType]::Tls12
# import modules and login
Import-Module MicrosoftPowerBIMgmt
Import-Module MicrosoftPowerBIMgmt.Profile
Connect-PowerBIServiceAccount
# initialize variables
$uriGroups = 'https://api.powerbi.com/v1.0/myorg/groups'
Write-Host "******* Reading Workspaces *****"
try {
$workSpacesJson = Invoke-PowerBIRestMethod -Url $uriGroups -Method Get
$workspaceContents = $workSpacesJson | ConvertFrom-Json
$workspaceCount = $workspaceContents.value.count
$workspaces = $workspaceContents.value
Write-Host "Total workspaces:" $workspaceCount
# loop thru the workspaces and get the reports
foreach ($workspace in $workspaces) {
$uriReports = $uriGroups + "/" + $workspace.id + "/reports?$expand=endorsementDetails"
$reportsJson = Invoke-PowerBIRestMethod -Url $urireports -Method Get
$reportsContents = $reportsJson | ConvertFrom-Json
$reportsCount = $reportsContents.value.count
#$reports = $reportsContents.value
Write-Host "Total reports in workspace:" $reportsCount
Write-Host "******* Exporting workspaces to json file *****"
$ExportFile = "./export/Reports_"+$workspace.name+".json"
$reportsJson | Out-File $ExportFile
}
if (-Not $?) {
$errmsg = Resolve-PowerBIError -Last
$errmsg.Message
}
} catch {
$errmsg = Resolve-PowerBIError -Last
$errmsg.Message
}
Write-Host "******* Exporting workspaces to json file *****"
$ExportFile = "./export/WorkSpaces.json"
$workSpacesJson | Out-File $ExportFile
Disconnect-PowerBIServiceAccount
