Below is my code to try and get the datasource names for all the datasources for every report in my power bi service. It is the workspace and dataset correctly but it is not getting the datasource name correctly. for datasource name it just returns a blank like so, "Datasource: ". But what it does do correctly is return the number of Datasources. So, for example if a report has 3 datasources it will return "Datasource: " 3 times. Any help would be very appreciated.
Install-Module -Name MicrosoftPowerBIMgmt.Data
Login-PowerBI
# Fetch all workspaces
$workspaces = Get-PowerBIWorkspace
foreach ($workspace in $workspaces) {
Write-Output "Workspace: $($workspace.Name)"
# Get datasets for each workspace
$datasets = Get-PowerBIDataset -WorkspaceId $workspace.Id
foreach ($dataset in $datasets) {
Write-Output " Dataset: $($dataset.Name)"
# Get datasources for each dataset in the current workspace
$datasources = Get-PowerBIDatasource -DatasetId $dataset.Id -WorkspaceId $workspace.Id
foreach ($datasource in $datasources) {
Write-Output " DataSource: $($datasource.Name)"
}
}
}
