Get All PowerBI Workspaces and the Datasets and What Datasource they use.

GetPowerBIDataSets.ps1

# Login to PowerBI Service
Connect-PowerBIServiceAccount

# Get all Workspaces from the Organization that start with UK.
$UKWorkspaces = Get-PowerBIWorkspace -scope Organization -all | Where-Object {$_.name -like 'uk*'}

# For Each Workspace workout the Datasets and the Datasources that correspond to them.
foreach ($workspace in $UKWorkspaces)
  {
    $ukdatasets = $workspace | Get-PowerBIDataset -scope Organization
  
  foreach ($dataset in $UKdatasets)
    {
     $source=$dataset|Get-PowerBIDatasource -scope Organization
     $props=[ordered]@{
     "WorkSpaceName"=$workspace.Name;
     "WorkSpaceID"=$workspace.Id;
     "DatasetName"=$dataset.Name;
     "DatasetID"=$dataset.Id;
     "Gateway"=$source.gatewayid;
     "source"=$source.datasourceid;
    }    
  $obj=New-Object -TypeName psobject -Property $props
  Export-Csv -path "c:\temp\dataset.csv" -InputObject $obj -Append -NoTypeInformation
}
}