How to return a specified dataset ID

[powerbi_jenhen]

Hi,

I have the below code where the source XML file has a single element for the desired dataset Name to return the ID for:

$DatasetName = $xmlElm.Workspace.Dataset.Default

$Dataset = Get-PowerBIDataset -WorkspaceId $Workspace.Id -Name $DatasetName

$DatasetId = $Dataset.ID

Write-Host "Dataset ID: "$DatasetId

The above code works if there is only one dataset in the workspace but when there's multiple datasets the $DatasetId variable contains the multiple dataset ids concatenated, I would have thought the "-Name" filter would have only returned the dataset id for this one named dataset? How can I change my code to do this?

Thanks. 

[powerbi_jenhen · Accepted solution]

I needed to use Where-Object:

$Dataset = Get-PowerBIDataset -WorkspaceId $Workspace.Id | Where-Object {$_.name -eq $DatasetName}