Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
lokeshb31
Helper II
Helper II

Extracting Workspace Details

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. 

1 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.

View solution in original post

7 REPLIES 7
v-yangliu-msft
Community Support
Community Support

Hi  @lokeshb31  ,

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

v-yangliu-msft_0-1610962708840.png

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

v-yangliu-msft_1-1610962708876.png

 

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.

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? 

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.

Hi  @lokeshb31 ,

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

v-yangliu-msft_0-1611125699553.png

 

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.

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

 

options.JPG

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
Helper II
Helper II

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

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors