cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Thiago_Sgarbi
Frequent Visitor

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

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?

 

1 ACCEPTED SOLUTION
Thiago_Sgarbi
Frequent Visitor

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

View solution in original post

5 REPLIES 5
Thiago_Sgarbi
Frequent Visitor

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

v-jianboli-msft
Community Support
Community Support

Hi @Thiago_Sgarbi ,

 

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

 

vjianbolimsft_0-1664266845305.jpeg

 

 

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.

Hi,

 

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

v-jianboli-msft
Community Support
Community Support

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.

          vjianbolimsft_0-1664245138161.png

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.

 

 

 

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.

 

Thiago_Sgarbi_0-1664263150754.png

 

Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.

Top Kudoed Authors