Sharepoint usage stats report in Power BI

[pavan363]

Hi All

I have requirement to create sharepoint usage stats report in power bi, there is usage report in sharepoint online where I can export 90 days of stats to CSV manually and create report, I would like to automate the approach.
Tried Office 365 Admin Center application re-use and Power shell script
Is there any other way which we can generate or consume share point usage stats report in Power BI.

Thanks!

[pavan363]

Hi @cpayton I have looked into it but no use if you can share any documentation which you have implented for the simila usecase that would be great Thanks!

[cpayton]

I haven't used the Graph API before, but we did manage to get PBI usage data out of the PBI Admin API which I would guess is similar. It required setting up an app in Azure for the authentication and used an SSIS package. I'm not a data engineer so not my area of expertise - I would personally try this because I'm more Python-inclined: https://github.com/O365/python-o365 

[pavan363]

Hi @cpayton  I am looking for share point usage stats, have done research from my side couldn't able to complete the working solution!

[cpayton]

If you want to do it the easy, manual way, you can export the data from the O365 audit logs in the admin portal. There's an activity type in there that is for viewing items in SP. 

[cpayton]

Have you looked into the MS Graph API? https://learn.microsoft.com/en-us/graph/api/resources/sharepoint-site-usage-reports?view=graph-rest-... 

It'd require some data engineering work, but you should be able to get something out of there.