Forum Discussion
Usage Metrics Report - Not Working For Certain Reports
Hi,
I have all my reports on one workspace, since then i can have a custom report based on the Usage Metrics Report dataset, but it only counts 52 report, even when I know I have more reports. Is there a known limit for how many reports it can handle?
Regards
Try this guideline step by step:
1. Check the Usage Metrics semantic model's refresh history and owner. Go to Workspace Settings → Semantic models tab → find "Usage Metrics Report" → check last refresh date, owner, and credential status. If credentials are expired or the owner is inactive, that's the culprit.
2. Reset the semantic model entirely. Each unique Usage Report comes with its own dataset, typically owned or managed by its initial creator. A common challenge arises when this user leaves the company or deactivates their account, the dataset stops refreshing, with no obvious indicators pointing to this issue. The proven fix is to delete the hidden semantic model via the REST API (Datasets - Delete Dataset In Group) and regenerate it fresh by clicking "View usage metrics" on any report.
3. If it persists after a reset, raise a Microsoft support ticket. This specific pattern, existing, active reports with no GUID resolution and no App involvement, is something that needs Microsoft to inspect the backend telemetry pipeline for that workspace. It may be a cluster-level issue.
The Activity Log (GetActivityEvents REST API) can also serve as a reliable alternative to confirm the views are actually being captured at the tenant level, independent of the Usage Metrics UI.
12 Replies
Hi JernbergMagnus,
The "52 reports" you're seeing is almost certainly not a built-in cap. Microsoft does not document any numeric limit on how many reports the Usage Metrics Report dataset can track within a single workspace.
The Usage Metrics report only includes reports that have been accessed in the last 90 days. If a report is not displayed, it may not have been used for more than 90 days.
So if you have, say, 80 reports in your workspace but only 52 have been opened by any user in the past 90 days, only those 52 will appear in the dataset. The rest exist in the workspace but simply have no activity to report.
For full inventory tracking, you'd need to complement it with the Power BI Admin REST APIs (GetReportsAsAdmin) which return all reports regardless of usage.
Hope this helps! Don't forget to mark as solution ✅ and thumbs up 👍 in order to keep helping others 🙂
Oussama
Data Consultant - Expert Fabric & Power BI
But if i know the missing reports have been used? If I try to open the Usage reports for the missing ones, they come out blank with missing Report ID in the bottom right hand corner. It looks like the views maybe comes under the report (Blank) something i would understand if the report was deleted, but it is still there and people use it...
Are those missing reports published inside a Power BI App?
Hi JernbergMagnus,
If you're still struggling with usage metrics data, I would recommend pivoting to the GetActivityEvents API.
https://learn.microsoft.com/en-us/rest/api/power-bi/admin/get-activity-eventsThis will allow you to pull all activity events and build your own tenant wide usage metrics report without relying on the hidden semantic models from the individual report level usage metrics.
Hi JernbergMagnus,
Thank you for posting your query in the Microsoft Fabric Community Forum.
you may consider the following:- The Usage Metrics report is based on an underlying dataset that can include usage data for all reports within a workspace, but the default view or copied report may apply filters.
- Usage metrics have certain data coverage and telemetry considerations, and the report reflects activity data within a defined time window and based on available telemetry
For your reference:
Monitor report usage metrics – Power BI
Monitor usage metrics in Power BI workspaces (preview)If the issue still persists, feel free to share more details and we can assists you.
Thanks,tayloramy and oussamahaimoud for sharing valuable insights.
Best regards,Anusha Bandari.
Hi JernbergMagnus,
Are those missing reports in workspaces that are attached to the capacity, or are they in Pro workspaces with no capacity?
Hi JernbergMagnus,
Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.
Thank you.Hi JernbergMagnus ,
May I check if this issue has been resolved? If not, Please feel free to contact us if you have any further questions.
Thank you.
