Create SharePoint Communication Site Analystics in Power BI

[MartinaHawkins]

Hi,

I would like to view our Intranet statistics in Power BI. Can anyone help me on how I go about pulling this information into Power Bi.

I will like to see Page and Document views.

[V-lianl-msft · Accepted solution]

Hi @MartinaHawkins ,

SharePoint On-Premise or SharePoint Online?

 Not all information tracked is available in SharePoint On-Premise and SharePoint Online.

You can refer to these:

https://support.microsoft.com/en-us/office/configure-audit-data-for-a-site-collection-a9920c97-38c0-... 

https://github.com/MicrosoftDocs/microsoft-365-docs/blob/public/microsoft-365/admin/usage-analytics/... 

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

Ask your tenant admin to help get the statistics.  Push the resulting data into a dataflow.  Consume the dataflow in Power BI.

[MartinaHawkins]

Hi, I am a tenant admin.  The stats that show in the dashboards are very high level and basic.  I want to drill down to see how many users are viewing all the documents that are uploaded to our Intranet. I added MS365 Usage Analytics App to Power Bi but that doesn't seem to give me information on Communication Sites, only Team sites and still does not give me user/document details. The Site Analytics on Comminication sites is not great.  I have several Communication sites and I would like to see all the data in Power BI.