Extracting Workspace Details

[lokeshb31]

Hello,

I did export all workspace details from tenant admin portal where I could see Worskapce ID, name, Description, Type, State, Read Only, Onprem capacity and Workspace upgrade status. However as an admin, I need to know who created the workspace and who all are members along with their access details (workspace admin, contributor, member, viewer) 

Please let me know if there is a way to extract this data. 

[v-yangliu-msft]

Hi  @lokeshb31  ,

1. You can view the permissions of roles in access in the upper right corner of the workspace：

2. About the creator of workspace, you can check here:

Website:https://protection.office.com

Select audit log search to capture the operation in power Bi and enter workspace in the search box

For related content, you can view this link:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing

https://community.powerbi.com/t5/Service/To-get-Power-BI-workspace-and-report-details-in-organisatio...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lokeshb31]

Thanks for details. I did install the PBI cmdlets and able to get workspace details but its all in raw format. Is there is a way to extract it in documented format like excel? 

[v-yangliu-msft · Accepted solution]

Hi  @lokeshb31  ,

Sorry, I misunderstood what you meant.

For PowerShell, get the desired result and export it to excel，you can check the document:

https://docs.microsoft.com/en-us/power-bi/admin/service-admin-auditing#use-powershell-to-export-audi...

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[v-yangliu-msft]

Hi  @lokeshb31 ,

You can export the details here, the export results on the far right

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lokeshb31]

I dont see any search options in https://protection.office.com for Audit log search.  Are there any privileges missing? 

[v-yangliu-msft]

Hi  @lokeshb31 ,

You must meet these requirements to access the Power BI activity log:

1. You must either be a global admin or a Power BI service admin.

2. You have installed the Power BI Management cmdlets locally or use the Power BI Management cmdlets in Azure Cloud Shell.

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

[lokeshb31]

Can anyone please help with this? We need these details for auditing and tracking purpose.