PowerBI Collects all server info for workspaces and datasets

GetPowerBIDataSetInfo.ps1

# Install PowerBI PowerShell if needed.
Install-Module -Name MicrosoftPowerBIMgmt

# Connect to PowerBI Service In PowerShell
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
	if ($source)
	{
		$GetURL = "https://api.powerbi.com/v1.0/myorg/groups/$($workspace.Id)/datasets/$($dataset.id)/datasources"
		$json = Invoke-PowerBIRestMethod -Url $GetURL -Method GET
		$jsonobject = ConvertFrom-Json -InputObject $json
		$props=[ordered]@{
     		"WorkSpaceName"=$workspace.Name;
     		"WorkSpaceID"=$workspace.Id;
     		"DatasetName"=$dataset.Name;
     		"DatasetID"=$dataset.Id;
     		"Gateway"=$source.gatewayid;
     		"source"=$source.datasourceid;
		"Datasource Type"=$jsonobject.value.Datasourcetype;
		"server"=$jsonobject.value.connectiondetails.server;
		"database"=$jsonobject.value.connectiondetails.database;
    }    
 $obj=New-Object -TypeName psobject -Property $props
 Export-Csv -path "c:\temp\datasettest3.csv" -InputObject $obj -Append -NoTypeInformation
	}
}
}