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.
Have any of those missing reports ever been deleted and re-published, or published from Desktop to replace an existing one?
No, they have always remained on the workspace, for at least the last week.
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.