SharePoint Site Analytics connection to PowerBI

[Vik2112]

Hello everyone,

I am quite new to Power BI. My company requires a report from SharePoint for site statistics, including content types (pages and documents) and visits. From the SharePoint site usage, you can access Popular Content for only the past 7 days, but overall traffic shows all visits without specifying which content users attended.

Is there any way to connect directly from PowerBI to a SharePoint site to show the statistics of attended pages for 30-90 days?

Thank you for your help.

Best regards,
Vik

[christinepayton]

There's not a really great way to get this data that doesn't involve traditional data engineering work. You essentially need to query the activity API and store it in a database, then connect Power BI to that. 

https://learn.microsoft.com/en-us/office/office-365-management-api/office-365-management-activity-ap...