Why does PowerShell export nonsense when exporting SQL query result to CSV?

Question

PowerShell

I don't understand what I'm doing wrong. I have a PowerShell script, it connects to the database, makes a request and returns the result, I need to save this result in excel and CSV

$SqlConnection = New-Object System.Data.SqlClient.SqlConnection
$SqlConnection.ConnectionString = "Server=localhost\SQLEXPRESS;Database=msdb;Trusted_Connection=True;"
$SqlCmd = New-Object System.Data.SqlClient.SqlCommand
$SqlCmd.CommandText = "Select * from MSdbms"
$SqlCmd.Connection = $SqlConnection
$DataAdapter = new-object System.Data.SqlClient.SqlDataAdapter $SqlCmd
$Dataset = new-object System.Data.Dataset
write-output $DataAdapter.Fill($Dataset) | Out-Null
$Output = $DataSet.Tables
$Output 

Export-Csv -InputObject $Output -Append -NoTypeInformation -Path C:\Users\users\TestScripts\Report.csv

The result is displayed correctly on the screen,

but some kind of hat is displayed in CSV, I don’t understand where the error is.

Answer 1

Everything is much simpler, as it turned out

Invoke-Sqlcmd -Query "Select * from MSdbms" -ConnectionString "Server=localhost\SQLEXPRESS;Database=msdb;Trusted_Connection=True;" | Export-Csv  -Delimiter ';' -Path C:\Users\user\TestScripts\Report.csv -notypeinformation

Answer 2

And if so?
$output | select dbms_id,dbms | export csv...

Answer 3

because you put Tables in $Output, and you need the first one
$DataSet.Tables[0] | Export-Csv ....