Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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)?
Solved! Go to 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.
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.
Hi @Greg_Deckler TX for your prompt reply. Is it possible to access the O365 audit logs using Power BI?
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
114 | |
97 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |