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.
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?
@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 .
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.
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
102 | |
88 | |
63 |