How to access the number of hits/views of items/docs in a SP Library?

[EricDeferm]

Is there a possibility to access the number of hits/views of docs shared in a Sharepoint Library (0365) within Power BI?

The same information that's provided when you request Popularity Trends (for Files) or Most Popular Items (for Library) through the User Interface?

We can access SP Libraries & List via the 'SharePoint Online List' data source, but is that information then stored in the 'Activities' (or other) column(s) or is it stored in another object(s)?

[Greg_Deckler]

I do not believe that is stored within the list but rather collected through web metrics. I would think that perhaps the Office 365 audit logs would have that information.

[EricDeferm]

Hi @Greg_Deckler TX for your prompt reply. Is it possible to access the O365 audit logs using Power BI?

[Greg_Deckler · Accepted solution]

There is an App/Content Pack for Azure Audit Logs but not Office 365 Audit logs. This came up at least once before here:

https://community.powerbi.com/t5/Integrations-with-Files-and/Office-365-Audit-Log/td-p/16512

The reply at the end is probably your best bet, use Powershell to download your audit log and then import and analyze with Power BI. This article includes how to use Powershell to search your audit logs:

https://powerbi.microsoft.com/en-us/documentation/powerbi-admin-auditing/

This article focuses on Power BI audit logs but Power BI audit logs are in the Office 365 audit logs so you should be able to modify the Powershell for your specific purposes.