topic Re: PowerShell Export-Csv not as expected in Developer

PowerShell Export-Csv not as expected

Anonymous — Tue, 22 Dec 2020 09:33:58 GMT

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

lbendlin — Tue, 22 Dec 2020 20:00:29 GMT

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

Anonymous — Mon, 28 Dec 2020 09:21:23 GMT

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