title: Powershell: Format-Table | Export-Csv
body: <p>I need to export some data out of Power BI Admin portal.</p>
  <pre><code>Get-PowerBiWorkspace | Format-Table | Export-Csv &quot;MyFile.csv&quot;
  </code></pre>
  <p>Now one would expect to have the data in the csv. But the results of <code>Get-PowerBiWorkspace | Format-Table</code> are not in the csv, just one column and a lot of empty columns.</p>
  <p>What am I doing wrong?</p>