Forum Discussion
SharePoint Site Analytics connection to PowerBI
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
1 Reply
- christinepayton
Most Valuable Professional
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.
