The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
97 | |
80 | |
62 | |
57 |
User | Count |
---|---|
264 | |
120 | |
115 | |
83 | |
70 |