Forum Discussion
Export SharePoint Site Analytics
Can we export data from /_layouts/15/siteanalytics.aspx?view=19?
I would like to get data on Most Viewed and Most Unique Viewers. Currently, it only shows Past 7 days. There is no way to change it.
Please help.
6 Replies
- You need to use the office 365 management API for usage and retrieve the data on a schedule and store in your own database, you can then use PowerBI to report on top of that. You need to register an Azure AD app and give it permissions to use this API. If you have a Flow P1 you could use this to query the API on a schedule and SQL Server connector to write to a database
Why do Microsoft make life so difficult? Exporting stats should be basic stuff.
Rob
Los GallardosReally would like to show it in a power bi report, there should be a direct way to push it to reporting tools like powerbi, or any export method to get the data.
Alan Marshall, thank you so much. Is there documentation on how to achieve this?
- This link provides the documentation for the activity API: https://docs.microsoft.com/en-us/office/office-365-management-api/office-365-management-activity-api-reference
