PowerShell Export-Csv not as expected

[Anonymous]

hello, i am trying to export results as a table to a csv

Get-PowerBIWorkspace | Format-table | Export-Csv C:\Users\spaldg\Downloads\wksp.csv -NoTypeInformation

when displayed on screen (without the Export) it looks fine

but when saved as a .csv, this is what i get

what am i doing wrong ?

thanks

g

[Anonymous]

Hi @Anonymous ,

Please update the command line as follow and check whether you can get what you want:

Get-PowerBIWorkspace | Format-table | Export-Csv -Path C:\Users\spaldg\Downloads\wksp.csv -NoTypeInformation -Delim ";"

Export-Csv

Best Regards

[lbendlin · Accepted solution]

Generally you don't want to use Export-Csv - Write-Output  gives you better control over the result, especially for true CSV files.

But if you're sticking with Export-Csv, read this article

Why Can’t I Pipe Format-Table to Export-Csv (and get something useful)? | PowerShell (microsoft.com).