Report Metrics Usage Report Model not refreshing from 2022-09-09

[Thiago_Sgarbi]

Hi,

I'm having trouble with the "Report Usage Metrics Model" Dataset, it's used in the old usage metrics report and I've tried to remove and recreate it, deactivate and reactivate the usage metrics in the admin section and it still doesn't work, the new report works (Usage Metrics Report Dataset) but I need the old model data to make my custom report to work.

Can you please help me?

[Thiago_Sgarbi · Accepted solution]

Ok, it's working again without any reason with a gap of 20 days of missing data, ty Microsoft.

[v-jianboli-msft]

Hi @Thiago_Sgarbi ,

Please first make sure the Usage Metrics setting in Tenant setting is enabled:

If you suspect data consistency or refresh issues, it might make sense to delete the existing Usage Metrics Report dataset. Then you can run View Usage Metrics again to generate a new dataset with its associated improved usage metrics reports. Please follow these steps to delete the dataset and then create a fresh data refresh report:

1. Open the workspace that contains the report for which you want to reset the Usage Metrics Report dataset.

2. In the black header bar at the top, select the Settings icon, then select Settings.

3. Switch to the Datasets tab, and select the Usage Metrics Report dataset.
4. Copy the workspace and dataset IDs from the URL displayed in the address bar of your browser.

5. In your browser, go to https://docs.microsoft.com/rest/api/power-bi/datasets/deletedatasetingroup, and select the Try It button.

6. Sign in to Power BI, paste the Workspace ID in the groupId text box and the dataset ID into the datasetId text box, and then select Run.
7. Under the Run button, verify that the service returns a Response Code of 200. That code indicates that the dataset and its associated usage metrics reports have been deleted successfully.

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thiago_Sgarbi]

Hi,

Already tried these solutions, as explained in the thread, delete and recreate, deactivate and reactivate the tenant settings.

[v-jianboli-msft]

Hi @Thiago_Sgarbi ,

You can create a usage report in Power BI Desktop, based on the Usage Metrics Report dataset. To establish a connection to the Usage Metrics Report dataset and create your own report, you have to be signed in to the Power BI service in Power BI Desktop.

1. Open Power BI Desktop.

2. If you aren't signed in to the Power BI service, on the File menu select Sign in.

3. To connect to the Usage Metrics Report dataset, on the Home ribbon select Get Data > More.

4. In the left pane, select Power Platform, then select Power BI datasets > Connect.

5. Scroll to the desired dataset or type Usage Metrics in the search box.

6. Verify in the Workspace column that you are selecting the correct dataset, then select Create.

          

Note: When you create a usage metrics report, it's built on the original dataset. If there are any changes from Power BI, this may break your copy of the report.

For more details, please refer to:

Monitor usage metrics in workspaces (preview) - Power BI | Microsoft Learn

Best Regards,

Jianbo Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Thiago_Sgarbi]

Hi, the problem is that this dataset doesn't show me data after 2022-09-09, and I'm sure there was a lot of access to that workspace reports.