Combine Usage Metrics Across Workspaces?

Hi,

I have a lot of experiance with the API's provided by Microsoft for Power BI.

If you have a data warehouse I recommend to store all your history there. You can also store history in Excel on a sharepoint site. Or Even better if you Are using Fabric.

I have created a smooth admin app with a lot of apis so I have full control of all of my workspaces, who has access to what and so on.

For your use case the ActivityEvent api is what you want to use.

Im using Fabric pipelines to fetch data and stores it on Fabric warehouse. You Can also use power Automate or Powershell.

Here is documentation on api:

https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-events

There is a lot of blogs with details on how you Can do it in diffrent ways.

Hi ncullen ,

Hi,

You're absolutely on the right track with wanting to centralize usage metrics across multiple workspaces. While the default Usage Metrics Reports are indeed limited to individual workspaces and only retain 30 days of history, there are ways to build a consolidated and extended view. One approach is to use the Power BI Activity Log, which provides detailed audit data across your entire tenant.

This data can be accessed via the Microsoft 365 Compliance Center or through the Office 365 Management API, and then ingested into Power BI for reporting. To automate this, you could set up a Power Automate flow or an Azure Logic App to pull log data on a scheduled basis and store it in a central location (e.g., SharePoint, Azure Blob Storage, or a SQL database). From there, you can build a semantic model in Power BI that refreshes regularly and retains historical data beyond the 30-day window. This approach gives you much more flexibility and control for tracking long-term usage across your organization.