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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
pavan363
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.

Thanks!

5 REPLIES 5
pavan363
Frequent Visitor

Hi @Anonymous 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!

Anonymous
Not applicable

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 

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

Anonymous
Not applicable

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. 

Anonymous
Not applicable

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.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors