Forum Discussion
Usage Metrics report
Hi Anonymous - Power BI Service’s usage metrics reports are typically limited to the past 30 days by default, which can be restrictive for month-over-month or long-term performance tracking.
Export Usage Metrics to a Separate Report: If you need historical data beyond the default 30 days, you can create a custom Power BI report. To do this:
- Export the usage metrics data to Excel or CSV format.
- Regularly save this data (e.g., monthly) to keep a longer record of usage history.
- Import these exported files into Power BI Desktop and create a custom report to visualize trends over multiple months.
- Connect to the Power BI Admin API: For more advanced solutions, Power BI’s Admin API provides access to comprehensive usage metrics with the ability to specify longer date ranges. You can use the Power BI REST API to pull data and create a custom report in Power BI Desktop that can capture usage over extended periods. To set this up:
- Use the Power BI REST API (specifically the event API) to query for user activity logs.
- Store the retrieved data in a database or data storage solution.
- Connect Power BI to this database to create custom usage and performance reports.
If your organization has Power BI Premium, you may have additional options for data retention. Premium workspaces can provide more flexibility in creating usage reports with extended date ranges, depending on your licensing level.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn
Hi Anonymous - Power BI Service’s usage metrics reports are typically limited to the past 30 days by default, which can be restrictive for month-over-month or long-term performance tracking.
Export Usage Metrics to a Separate Report: If you need historical data beyond the default 30 days, you can create a custom Power BI report. To do this:
- Export the usage metrics data to Excel or CSV format.
- Regularly save this data (e.g., monthly) to keep a longer record of usage history.
- Import these exported files into Power BI Desktop and create a custom report to visualize trends over multiple months.
- Connect to the Power BI Admin API: For more advanced solutions, Power BI’s Admin API provides access to comprehensive usage metrics with the ability to specify longer date ranges. You can use the Power BI REST API to pull data and create a custom report in Power BI Desktop that can capture usage over extended periods. To set this up:
- Use the Power BI REST API (specifically the event API) to query for user activity logs.
- Store the retrieved data in a database or data storage solution.
- Connect Power BI to this database to create custom usage and performance reports.
If your organization has Power BI Premium, you may have additional options for data retention. Premium workspaces can provide more flexibility in creating usage reports with extended date ranges, depending on your licensing level.
https://learn.microsoft.com/en-us/power-bi/collaborate-share/service-usage-metrics
Reports - REST API (Power BI Power BI REST APIs) | Microsoft Learn
As asma-k says it would be great to see a sample tutorial or guide for doing this automatially - it's going to be a common ask, and can be quite fiddly to set up.
30 days is not much use for our reporting which will have end of month, end of quarter and annual reports. There's not really oodles of data anyway - I'd much rather be able to say I want to keep 2 years of data.
