I'm using the PowerShell Script from https://insightsquest.com/2019/06/19/power-bi-artifact-to-workspace-relationships/, using my userid/pw to return all workspaces, and reports. essentially looping through all the workspaces to retrieve the reportname, reported, and workspace. I am getting the output I would expect, but I'm not sure if all the reports are retrieved.
$User = "userid@companyname"
$PW = "#useridpassword"
$SecPasswd = ConvertTo-SecureString $PW -AsPlainText -Force
$myCred = New-Object System.Management.Automation.PSCredential($User,$SecPasswd)
Login-PowerBIServiceAccount -Credential $myCred
$RetrieveDate = Get-Date
#1. Define output file paths
$BasePath = "C:\temp\New"
#Export Paths: Power BI Artifacts
$WorkspacesPath = $BasePath + "Workspaces.csv"
$ReportsPath = $BasePath + "Reports.csv"
#2. Get active workspaces excluding personal workspaces ('My Workspace')
$ActiveWorkspaces = Get-PowerBIWorkspace -Scope Organization -All <#| Where-Object {$_.Type -ne "PersonalGroup" -and $_.State -eq "Active"} #> |`
Select-Object *, @{Name="DateRetrieved";Expression={$RetrieveDate}}
#3. Get reports in active workspaces but avoid duplicate reports (due to apps) and exclude usage metrics reports
$Reports = ForEach ($WS in $ActiveWorkspaces)
{
$WSID = $WS.Id
Get-PowerBIReport -Scope Organization -WorkspaceId $WSID | Where-Object {$_.Name -ne "Dashboard Usage Metrics Report" -and $_.Name -ne "Report Usage Metrics Report"} | `
Select-Object Name,DatasetId,@{Name="WorkspaceID";Expression={$WSID}},@{Name="DateRetrieved";Expression={$RetrieveDate}} | `
Sort-Object -Property Name,WorkspaceID | Get-Unique -AsString
}
#4. Export out artifact objects to CSV files for reporting
$ActiveWorkspaces | Export-Csv $WorkspacesPath
$Reports | Export-Csv $ReportsPath
