Premium per user - Loop through workspace and get Connection Strings

Hi TCavins,

I have done the repro at my and got the below output:

Below code should run in Powershell

Connect-PowerBIServiceAccount

$workspaceId = "Enter your Workspacae ID here"

$datasets = Get-PowerBIDataset -WorkspaceId $workspaceId

foreach ($ds in $datasets) {

    Write-Host "==============================="
    Write-Host "Dataset: $($ds.Name)"
    Write-Host "==============================="

    # Datasources
    $urlDS = "https://api.powerbi.com/v1.0/myorg/groups/$workspaceId/datasets/$($ds.Id)/datasources"
    $sources = Invoke-PowerBIRestMethod -Url $urlDS -Method GET | ConvertFrom-Json
    $sources
    Write-Host "`nData Sources:"
    foreach ($s in $sources.value) {
        Write-Host "  Type: $($s.datasourceType)"
        Write-Host "  Server: $($s.connectionDetails.server)"
        Write-Host "  Database: $($s.connectionDetails.database)"
        Write-Host ""
    }

    Write-Host "`n"
}

Thank you.