Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Sharepoint usage stats report in Power BI

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.


Frequent Visitor

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!

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: 

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

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. 

Helper II
Helper II

Have you looked into the MS Graph API? 

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

Helpful resources

PBI Sept Update Carousel

Power BI September 2023 Update

Take a look at the September 2023 Power BI update to learn more.

Learn Live

Learn Live: Event Series

Join Microsoft Reactor and learn from developers.

Dashboard in a day with date

Exclusive opportunity for Women!

Join us for a free, hands-on Microsoft workshop led by women trainers for women where you will learn how to build a Dashboard in a Day!

Top Solution Authors