Showing results for 
Search instead for 
Did you mean: 
Community Champion
Community Champion

accesing "Site Report" data in SharePoint Online

In SharePoint Online, when an administrator goes to "Site Contents", there are a couple of reports available showing number of visits and trending content.:


SPO Site report.PNG









Can PowerBI connect to the raw data used to populate these reports?  I can't find it either as a SPO List or an SPO Folder.




Community Support
Community Support

Hi @dedelman_clng,


Based on my test, there is no OOTB feature available in Power BI Desktop for us to get data from SharePoint Online Site content page currently.


In my opinion, those reports like Site visits and Trending content are analyzed and generated by SharePoint Online itself. I would suggest you consult the SharePoint Online experts where are those reports data stored in this forum: Microsoft Online: SharePoint Online. If data stored in SharePoint Online list, then you can get data then design report by yourself in desktop. Otherwise, I'm afraid we are not able to do it in Power BI.


If you have any question, please feel free to ask.


Best Regards,
Qiuyun Yu

Community Support Team _ Qiuyun Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Join Arun Ulag at MPPC23

Join Arun Ulag at MPPC23

Get a sneak peek into this year's Power Platform Conference Keynote.

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
Top Kudoed Authors