Iteration on Powershell

amsrivas28 

So Get-PowerBIWorkspace will show (by default) the first 100 workspaces your user is assigned to, sso you'll probably want to get all workspaces you're assigned to by calling Get-PowerBIWorkspace -All.

I've not got any PowerBI workspaces that I can get "Get-PowerBIDataFlow" to run on but it apparently returns an object, which can be passed to ConvertTo-Csv, then pipe that to Out-File to stick it in a .csv. So hopefully something like this will do the job:

$workspaces = Get-PowerBIWorkspace -All
foreach ($workspace in $workspaces) {
  Get-PowerBIDataFlow -Workspace $workspace | ConvertTo-Csv | Out-File -FilePath "c:\output.csv" -Append
}

If not then you'll have to manipulate the data a bit - not sure what that cmdlet returns so can't say what that would be:

$workspaces = Get-PowerBIWorkspace -All
foreach ($workspace in $workspaces) {
  $data = Get-PowerBIDataFlow -Workspace $workspace 
  #do something with $data to get what you need into a variable called $csv
  $csv | Out-File -FilePath "c:\output.csv" -Append
}

Edit: Second attempt... first attempt replied to the wrong post and didn't read the question properly, haha.

amsrivas28 

You need to store the result of Get-PowerBIWorkSpace into variable and the use the variable in Step to

so it will be like this

$Result=Get-PowerBIWorkspace
Get-PowerBIDataFlow -WorkSpaceID $Result

This should help.

and also it might depend on the output of the first line

-----

If this answer helpful, please click on best Respone