how can i list Workspace and datasets by workspace

Hi Anonymous ,

Please refer to the code.

Connect-PowerBIServiceAccount


# Variable to receive the codes of the Power BI workspaces
$Workspace = Get-PowerBIWorkspace -All

# Loop for each workspace and for each dataset, get the data from the column below
$DataSets =
ForEach ($workspace in $Workspace)
    {
    Write-Host $workspace.Name
    ForEach ($dataset in (Get-PowerBIDataset -WorkspaceId $workspace.Id))
        {
        [pscustomobject]@{
            WorkspaceName = $Workspace.Name 
            WorkspaceID = $workspace.Id
            DatasetName = $dataset.Name
            DatasetID = $dataset.Id
            }
        }
    }

# Defines the directory and name of the file to be exported to the CSV file
$Dir = "C:\Users\lionelch\Desktop\Sampledata\MyWorkspace.csv"

# Exports the result to the CSV file in the directory informed above
$DataSets | Export-Csv $Dir -NoTypeInformation -Encoding UTF8


Disconnect-PowerBIServiceAccount

--My result

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.