top of page

Exporting the workspaces list from the Admin Portal

From Microsoft PowerBI blog:

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

232 views0 comments


bottom of page