Exporting the workspaces list from the Admin Portal

May 2, 2019

From Microsoft PowerBI blog: https://powerbi.microsoft.com/es-es/blog/exporting-the-workspaces-list-from-the-admin-portal/

 

 

Perhaps you wanted to export the list of workspaces placed on Premium capacities, as in the following screenshot. Or you simply wanted to export all workspaces and track over time how many workspaces are added or deleted. Whatever the scenario, the Workspace page now provides an Export command so that you can export the current list to a comma-separated values (CSV) file. The same export to CSV feature is also available on the Embed Codes page.

 

The export feature is self-explanatory. Export to CSV, then open in Excel, and perform any additional steps, as necessary. For example, you can format the list as a table and then apply additional filters in Excel, as in the following screenshot.

 

 

 

One aspect worth pointing out, however, is that the exported list does not include the full set of workspace properties that you can get from the Get-PowerBIWorkspace cmdlet. Specifically, the workspace ID is not included, which makes it hard to use this exported list as input for a PowerShell script for further workspace management automation. This will get better over time when more columns are added to the Workspace page.

 

 

 

Some opinions expressed in this article may be those of a guest author and not necessarily Analytikus. Staff authors are listed in https://powerbi.microsoft.com/es-es/blog/exporting-the-workspaces-list-from-the-admin-portal/

Please reload

Featured Posts

Analytikus LLC y BEXTechnology S.A., nueva alianza en ciencia de datos, machine learning e Inteligencia Artificial.

May 8, 2018

1/4
Please reload

Recent Posts
Please reload

Search By Tags
Follow Us
  • Facebook Social Icon
  • Twitter Classic
  • LinkedIn Social Icon
  • YouTube Social  Icon
  • itunes

© 2019 by analytikus, LLC - Privacy Policy

us_1821_499x335.jpg
EN
España.png
ES
  • LinkedIn Social Icon
  • Twitter Classic
  • Facebook Social Icon
  • YouTube Social  Icon
  • itunes