title: PowerBi List of all workspaces and users within - Newbie Question
body: <p>My job entails me rotating through different parts of our IT Team. I recently moved to our Analytics department and found myself utilizing Powershell to retrieve data for Power BI. Bear with me here as I am new to this...</p>
  
  <p>My goal is to generate a list of all the workspaces in our organization and the users correlated with each workspace. In general we want to try to get a wider-view on what is taking place within our tenant.  </p>
  
  <p>I've tried each of these methods with no success. </p>
  
  <p><a href="https://powershell.org/forums/topic/powerbi-query-trying-to-list-workspaces-and-users/" rel="nofollow noreferrer">https://powershell.org/forums/topic/powerbi-query-trying-to-list-workspaces-and-users/</a></p>
  
  <p><a href="https://stackoverflow.com/questions/54702764/how-to-extract-all-powerbi-users-and-workspace-access-using-the-powerbi-api-or-a">How to extract all PowerBI users and workspace access using the PowerBI API or Azure Portal?</a></p>
  
  <p>Ive also tried to run the command below but get the error of "System.Linq.Enumerable+WhereSelectListIterator`2" when it should be the user info.</p>
  
  <pre><code>Get-PowerBIWorkspace -Scope Organization -Include All -All |select-object | export-csv c:\temp\powerbiworkspaces.csv -NoTypeInformation
  </code></pre>
  
  <p>Any help would be greatly appreciated..</p>
  
  <p>Thank you in advance,</p>