Usage Metrics report not showing data

[ksenija_saulic]

Hi all,

My Usage Metrics report is not showing data from the last few months. I had some errors in datasets and I fixed them few days ago. Actually when "New Usage report off" I can see all the data, I only have problem when "New Usage report  on". Do you have any idea how to troubleshot this problem?

[ksenija_saulic · Accepted solution]

I deleted Usage Metrics dataset and now it's working okay

[123abc]

If you are facing issues with the Usage Metrics report in Power BI not displaying data after turning on the "New Usage report," there are several steps you can take to troubleshoot the problem. Here are some suggestions:

1. Check Dataset Refresh: Ensure that the dataset associated with the Usage Metrics report is being regularly refreshed. If there were errors in datasets that you fixed, make sure the data is refreshed to reflect the changes.

2. Verify Data Connection: Double-check the data connection settings for the Usage Metrics report. Ensure that the report is connected to the correct dataset, and that the dataset is connected to the correct data source.

3. Check for Errors: Review any error messages that may be associated with the report or dataset. Look for warnings or errors related to data refresh, queries, or connections. Address any issues reported in the error messages.

4. Power BI Service Settings: If you are using Power BI service, check the settings related to the new usage report. There might be specific settings or configurations that need adjustment.

5. Permissions: Verify that you have the necessary permissions to access and view the Usage Metrics report. Check both dataset and report permissions to ensure that you have the required access.

6. Clear Cache: Clear the browser cache or Power BI Desktop cache to ensure that you are not viewing cached data. Sometimes, cached data might cause discrepancies in the report.

7. Review Report Filters: Check if there are any filters applied to the report that might be excluding the data you expect to see. Ensure that the filters are set correctly.

8. Check for Scheduled Refresh Issues: If you are using the Power BI service and have scheduled refresh enabled, make sure there are no issues with the scheduled refresh process. Check the refresh history for any errors.

9. Review Power Query Editor: In Power BI Desktop, open the Power Query Editor and review the queries. Ensure that there are no errors or issues in the transformation steps.

10. Review Data Model Relationships: Check the relationships in the data model to ensure they are correctly defined. Incorrect relationships can result in data not being displayed correctly.

11. Update Power BI Desktop: Make sure you are using the latest version of Power BI Desktop. Updating to the latest version may resolve compatibility issues.

If the issue persists after going through these steps, consider reaching out to Power BI community forums, Microsoft support, or your IT department for further assistance. Provide detailed information about the issue, any error messages, and the steps you have taken to troubleshoot.

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

In case there is still a problem, please feel free and explain your issue in detail, It will be my pleasure to assist you in any way I can.

[RossEdwards]

"New Usage Report" only shows the last month of data, thats working as intended.  Its such a short period of time that our organisation extracts the usage data using the API and stores it locally instead.

[Anonymous]

Hi @ksenija_saulic 

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

Ensure that collecting per-user data in usage metrics is enabled if needed.

Check if the workspace hosting the report is on Premium Per User (PPU) or Shared capacity. If so, be aware that there is a known issue where activity might be filtered out, causing the new Usage Metrics report to display less activity than expected.

Troubleshoot with Alternative Methods:

Try using the usage metrics reports at the workspace level to measure usage instead. Consider pulling usage data using the activity events API as an alternative.

Verify if the new Usage Metrics report is configured correctly. Check for any filters or settings in the new report that might be excluding data.

Compare the legacy report with the new Usage Metrics report configuration to identify any discrepancies.

Regards,

Nono Chen

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