How get the Database name, Server Name, Dataset, Report Name and Workspace Name using PowerShell

$Workspaces = Get-PowerBIWorkspace -All
$Reports = ForEach ($workspace in $Workspaces) {
Write-Host $workspace.Name
ForEach ($report in (Get-PowerBIReport -WorkspaceId $workspace.Id)) {

ForEach ($datasource in (Get-PowerBIDatasource -DatasetId $report.DatasetId)) {
[pscustomobject]@{
WorkspaceID = $workspace.Id
WorkspaceName = $workspace.Name
ReportID = $report.Id
ReportName = $report.Name
DatasetID = $report.DatasetId
DataSourceName = $datasource.name
ConnectionString = $datasource.ConnectionString
ConnectionServer = $datasource.ConnectionDetails.Server
ConnectionDatabase = $datasource.ConnectionDetails.Database
ConnectionUrl = $datasource.ConnectionDetails.Url
GatewayID = $datasource.GatewayId
Datasoruceid = $datasource.DatasourceId
}
}
}
}
$Reports | Export-Csv -Path <mention path> -NoTypeInformation