Forum Discussion
PowerShell Export-Csv not as expected
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
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).
2 Replies
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).
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 ";" Best Regards