Sharepoint Metadata Retrieval

Question

Hello ,
Currently the SharePoint metadata were pulled using the below PowerShell commands.we are trying to pull the same metadata of sharepoint directly without powershell.What is the way we can directly fetch the same metadata info without powershell.

we Explered the option to connect to SharePoint from powerBI directly.However we could not collect all the info.The end goal is to load the sharepoint metadata into powerBI and then generate the report.

Powershell Commands:

================

Get-PnPTenantSite

Get-PnPWeb

Get-PnPProperty

Get-PnPGroupMembers

Get-PnPSiteCollectionAdmin

Get-PnBlistitems

Metadatawe are looking for:

================

owner details, user details, sensitive label, sharing details,site collection details,and external user info

Answer 1

Dear Sathish,

The out-of-the-box way instead of the PowerShell way is to use the Audit Log feature in Microsoft Purview and then export the corresponding Excel file, migrate them manually and connect them to Power BI.

For your reference: Audit log activities | Microsoft Learn

However, if you need a quicker way doing that, I think that you may need to use PowerShell or Rest API.

Thanks for your effort and welcome to share any updates if you need further help on this issue.

Sincerely

Cliff | Microsoft Community Moderator