Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
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.
Solved! Go to 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:
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 ,
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
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:
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
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?
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.
Can anyone please help with this? We need these details for auditing and tracking purpose.