Forum Discussion
SharePoint online usage analytics using powerbi usage analytics template
Hi,
I dowloaded Power BI Template file for O365 usage analytics from here : https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/customize-reports?view=o365-worldwide as a starting point to connect to the data and visualize the analytics. What I am looking for is that for "User activity" on SharePoint online, I don't see a way to filter the dataset by site collection. Currently, I only see "Department", Country, City as the filters. I am only looking to run these analytics for a single site collection that I am interested in. Any way to achieve this by modifying this template?
5 Replies
Refer, if this can help
https://powerbi.microsoft.com/en-us/blog/integrate-power-bi-reports-in-sharepoint-online/
https://www.petri.com/getting-started-power-bi-sharepoint-online-part-1
Appreciate your Kudos.
rythm26 ,
Based on your senario, the URL query string parameter may meet your requirement, for more details, please refer to:
https://docs.microsoft.com/en-us/power-bi/service-url-filters
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Sorry for not being clear. I am using the pbit file provided by microsoft for running usage analytics on O365 workloads. If anyone used this template, how to filter the analytics for a single site collection in SharePoint online. Currently this template has filters for country, department, state etc. but not a filter so that metrics can be filtered for a single site collection. Please help
did you find out a soludion for this ? i am looking in to the same scenario .
