powershell command to get datasource name is not working

Hi momo_man,

To retrieve the datasource names correctly, you can use the DataSources property of the dataset. Here's an updated version of your script that should correctly display the datasource names (I am not able to test the script at the moment):

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 the dataset details, including datasources
        $datasetDetails = Get-PowerBIDataset -WorkspaceId $workspace.Id -Id $dataset.Id -Detail

        foreach ($datasource in $datasetDetails.DataSources) {
            Write-Output "    DataSource: $($datasource.Name)"
        }
    }
}

My idea is to use the -Detail parameter with Get-PowerBIDataset to get all the dataset details, including datasources, and then looping through the DataSources property to get and display the datasource names.