SharePoint Audit Report using Power BI

[Anonymous]

Hello,

I am trying to built an audit report for SharePoint online site collection. I am not sure which data source I need to connect to get site specific audit data.

Please note this is for a specific site collection, not for all site collection under SP tenant.

Thanks,

JD 

[lbendlin · Accepted solution]

You may want to be a bit more specific as to what audit data you are after.  Here's an example of how to get document level audit data via Powershell

https://social.technet.microsoft.com/wiki/contents/articles/23900.sharepoint-get-audits-for-a-docume...

Here's another one that allows you to search for specific entries

https://www.codetwo.com/admins-blog/enable-view-sharepoint-online-logs/

[edhans · Accepted solution]

You can't connect directly to the audit logs via Power Query that I am aware of. You will need to connect to CSV exports. As @lbendlin indicated, you can do this via Power Shell. You can also manually export the logs via the Audit Log search tool at protection.office.com for your tenant and filter for SharePoint.

[lbendlin · Accepted solution]

You may want to be a bit more specific as to what audit data you are after.  Here's an example of how to get document level audit data via Powershell

https://social.technet.microsoft.com/wiki/contents/articles/23900.sharepoint-get-audits-for-a-docume...

Here's another one that allows you to search for specific entries

https://www.codetwo.com/admins-blog/enable-view-sharepoint-online-logs/