SharePoint online usage analytics using powerbi usage analytics template

[rythm26]

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-wor...   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?

[harshnathani]

HI @rythm26 ,

https://community.powerbi.com/t5/Data-Stories-Gallery/Microsoft-365-Usage-Analytics/m-p/953660

Regards,

HN

[v-yuta-msft]

@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.

[rythm26]

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

[danielH]

did you find out a soludion for this ? i am looking in to the same scenario . 

[amitchandak]

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.