Forum Discussion
Usage Metrics Report - Not Working For Certain Reports
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.
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?
No Power BI Apps, just straight to the service.
Have any of those missing reports ever been deleted and re-published, or published from Desktop to replace an existing one?