Forum Discussion
Powershell Get-PowerBIDatasource - Name is blank
I'm using the following Powershell script to output a file that includes Workspace, dataset and datasource info. The Datasource name is always coming back empty. How can I loop through and get the info I want?
Install-Module -Name MicrosoftPowerBIMgmt -Scope CurrentUser
Login-PowerBI
$Workspace = Get-PowerBIWorkspace –All
$DataSets =
ForEach ($workspace in $Workspace)
{
Write-Host "Workspace: "
Write-Host $workspace.Name
ForEach ($dataset in (Get-PowerBIDataset -WorkspaceId $workspace.Id))
{
ForEach ($ds in (Get-PowerBIDatasource -DatasetId $dataset.Id -Scope Organization))
{
[pscustomobject]@{
WorkspaceName = $Workspace.Name
WorkspaceID = $workspace.Id
DatasetName = $dataset.Name
DatasetID = $dataset.Id
DatasourceName = $ds.Name
}
}
}
}
$Dir = "C:\pbi_test.csv"
$DataSets | Export-Csv $Dir -NoTypeInformation -Encoding UTF8
Write-Host "File created in " $Dir
Disconnect-PowerBIServiceAccount3 Replies
- AnonymousNot applicable
Hi TCavins ,
As far as I know, Datasource Name should be in -Name part. It should look like-Name DatasoureName.
Get-PowerBIDatasource -Dataset <Dataset> [-WorkspaceId <Guid>] -Name <String> [-Scope <PowerBIUserScope>] [<CommonParameters>]For reference: Get-PowerBIDatasource
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
- TCavinsHelper V
Anonymous
Thanks. I'm trying to return the dataset name or the source name of the dataset. From my understanding, the -Name is used for when you know the name and want to return records with a datasource of that name.I don't know the names and we are trying to programmatically return all reports with their datasets/sources that are used in them so we can analyze it from there.
- momo_manFrequent Visitor
did you ever solve it. I am actually having the same issue