Forum Discussion
Usage Metric Semantic Model
Hi dogt1225,
The steps you mentioned for creating the Usage Metrics Report are absolutely correct and required. But clicking on Viewing Usage Metrics Report merely creates a report while utilizing any existing Usage Metrics Model in the workspace, that you mentioned is outdated and not refreshing.
Hence, the underlying Usage Metrics Report Model needs to be deleted first, then we would be able to reset and force a new updated usage metrics dataset that refreshes correctly.
To delete the Usage Metrics Model, you can make you use of Power BI Datasets - Delete Dataset In Group API which would help in deleting the dataset by specifying the workspace ID and dataset ID.
I would have mentioned the detailed steps here, but I found a blog that goes through this process in detail, explaining everything step by step - https://dadataguy.medium.com/a-step-by-step-guide-to-resetting-your-power-bi-usage-metrics-dataset-9b01e787e47
I also followed the same steps to reset the metrics model in my workspace and get it working. Let me know if it works for you!
Hi dogt1225,
Generally, if the usage metrics report/ model has been deleted or not refreshing, creating a new usage metrics report for any of the reports in the workspace resets things for me.
Even if the usage metrics report has stopped refreshing due to inactivity and isn't resuming refresh automatically, we delete the usage metrics model and create a new one which fixes things.
- Have you tried creating a new usage metrics report for any other report in the workspace? Is it working?
- Hope you have an admin role in the workspace or appropriate permissions on the dataset?
Let me know if it doesn't work, we can try investigating further.
Hi Bipin-Lala
Thank you for your respone. I am an admin of the workspace. I did try creating a new usage metric report for other reports within the workspace, but they are also not working and all have a last refresh date of 10/29/2024.
Here are the steps I took to recreate a new usage report. Please let me know if I am missing a step:
1.) Within Workspace, I hovered over a report > Select the elipsis (...) > Select "View usage metrics report"2.) Message appears on the top-right stating usage metrics are ready. I select the green box "View usage metrics.
3.) It brings me to a new page with the Usage Metrics Report, however has a last update date of 10/29/2024. I follow the same steps for other reports within the workspace and results are the same.
Hi dogt1225,
The steps you mentioned for creating the Usage Metrics Report are absolutely correct and required. But clicking on Viewing Usage Metrics Report merely creates a report while utilizing any existing Usage Metrics Model in the workspace, that you mentioned is outdated and not refreshing.
Hence, the underlying Usage Metrics Report Model needs to be deleted first, then we would be able to reset and force a new updated usage metrics dataset that refreshes correctly.
To delete the Usage Metrics Model, you can make you use of Power BI Datasets - Delete Dataset In Group API which would help in deleting the dataset by specifying the workspace ID and dataset ID.
I would have mentioned the detailed steps here, but I found a blog that goes through this process in detail, explaining everything step by step - https://dadataguy.medium.com/a-step-by-step-guide-to-resetting-your-power-bi-usage-metrics-dataset-9b01e787e47
I also followed the same steps to reset the metrics model in my workspace and get it working. Let me know if it works for you!
This works! Thank you!
