How to Refresh Usage Metrics Report in Power BI

Your new Power BI report is finally live, but now comes the real test: is anyone actually using it? The Usage Metrics report holds the answer, but its data isn't always as fresh as you'd like. This guide will walk you through exactly how to manually refresh your Power BI usage metrics, so you can get a more current view of your report's performance and engagement.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

What is the Power BI Usage Metrics Report?

Before diving into the refresh process, let's quickly review what this report is and why it's so useful. For every report or dashboard you publish in a Power BI workspace, Power BI automatically generates a pre-built "usage metrics" report. This special report gives you insights into how your content is being consumed.

Think of it as the analytics backend for your BI content. It answers critical questions like:

• How many people have viewed my report? (Total Views and Unique Viewers)
• Who are my most active users? You can see a list of users who have viewed the report and when their last view was.
• Is the report being shared? It tracks views by the share method.
• Which pages within the report are most popular? Page-level analytics help you understand which insights resonate most.
• How is the report performing? It includes performance data, showing typical report opening times, which can help you identify slow-loading visuals or DAX measures.

This information is invaluable for any report creator. It helps you justify the need for a BI tool, understand user adoption, gather feedback, and focus your efforts on improving the content that people actually use.

Understanding Data Freshness in Usage Reports

One of the first things users notice about the usage metrics report is that the data isn't real-time. If you view a report and then immediately check the usage metrics, you won't see your view reflected. This is by design.

Power BI collects usage activity in the background and processes it periodically. By default, the dataset that powers the usage metrics report is set to refresh once every 24 hours. This means that under normal circumstances, the data you're looking at could be up to a day old.

For regular monitoring, a 24-hour delay is often fine. But there are specific situations where you might need more timely insights, and that’s where knowing how to force a manual refresh comes in handy.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Why You Might Need to Refresh Manually

Waiting a full day for updated usage data isn't always ideal. You might want to trigger a manual refresh in several scenarios, such as:

• After a major new report launch: You just shared a brand new, highly anticipated report with the entire company. You'll want to see the initial engagement and adoption numbers sooner rather than later.
• Following a report update: You have an existing, widely used report and you just rolled out a significant update with new features or pages. You'll want to quickly see if people are using the new additions.
• Preparing a presentation: You're about to present on the "state of analytics" to leadership and you need the absolute latest numbers on report adoption to include in your slides.
• Troubleshooting access or performance: A user reports an issue, and you want to confirm if their access attempts or activity are being registered in the logs promptly.

In these cases, forcing the report to update gives you a much clearer, more current picture of what's happening.

Step-by-Step Guide to Refreshing the Usage Metrics Report

Refreshing the usage metrics isn't as simple as clicking a refresh button on the report itself. The secret is knowing that the usage metrics report is just like any other Power BI report - it's powered by an underlying dataset. The key is to find that specific dataset and refresh it directly. Here’s how.

Step 1: Navigate to Your Usage Metrics Report

First, open the regular usage metrics report to establish a baseline. You can’t refresh it from here, but you’ll want to note the latest data to confirm it worked later.

1. Go to the Power BI workspace that contains the report or dashboard you want to analyze.
2. Find your target report in the list.
3. Hover over it or click the "..." (More options) menu.
4. Select View usage metrics report.

Take a look at the "Date" slicer or the latest activity date shown in the tables. This is the information you'll be updating.

Step 2: Understand the Underlying Dataset

When you first view the usage metrics for a report, Power BI silently performs two actions in the background:

1. It creates the usage metrics report itself.
2. It creates a new, hidden dataset that contains all the usage data and connects it to the report.

This dataset is automatically named in a standard format: Usage Metrics Report - [Name of Your Original Report]. For instance, if your report is named "Quarterly Sales Review," the dataset will be called "Usage Metrics Report - Quarterly Sales Review." This is the target you need to find.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Step 3: Find the Usage Metrics Dataset in Your Workspace

Now, let's locate that special dataset. It lives inside the same workspace as your original report.

1. Go back to the main content list for your workspace.
2. Above the list of content, you’ll see filters for "All," "Content," "Data," etc. Click on the Datasets + dataflows filter (or a similar name, as the UI can change). This will hide all the reports and show only the data assets.
3. Now, look through the list for the dataset named "Usage Metrics Report - [Name of Your Original Report]". It should have a dataset icon (usually a stack of cylindrical blocks).

If you have many assets in your workspace, you can use the search bar to find it quickly. Just type in "Usage" and it should pop right up.

Step 4: Manually Refresh the Dataset

This is the magic step. Once you've found the dataset, you have full control over it, including the ability to manually refresh it.

1. In the dataset list, hover your mouse over the usage metrics dataset.
2. A few icons will appear. Click the Refresh now icon, which looks like a circular arrow.
3. You’ll see a small spinning icon appear to indicate the refresh is in progress. Depending on how much usage data there is, this can take anywhere from a few seconds to a minute. Wait for it to complete.

Once the spinning icon disappears, the process is complete. Your usage metrics dataset now contains the most up-to-date data Power BI has processed from its backend logs.

Step 5: Verify the Refresh

To confirm your work, circle back to the usage metrics report.

1. Return to your original report (you can change the filter back to "All").
2. Click on the "..." menu and select View usage metrics report again.
3. The visuals in the report should now reflect more recent data. Check the latest dates in your tables or adjust the date slicer to see if new entries for today have appeared.

If you see more recent activity that wasn’t there before, congratulations! You have successfully refreshed your usage metrics.

Troubleshooting Common Issues

Sometimes things don't go as planned. Here are some common roadblocks and how to navigate them.

Problem: The "Refresh Now" Button is Greyed Out

If you find the dataset but can't click the refresh icon, it's almost always a permissions issue. To refresh a dataset (even an auto-generated one), you need to have a workspace role of Member, Contributor, or Admin. If you are only a "Viewer," you won't have the necessary permissions. You'll need to ask someone with higher access to perform the refresh for you.

Graphed

Still Building Reports Manually?

Watch how growth teams are getting answers in seconds — not days.

Watch the Demo

Problem: Data Still Seems Outdated After Refresh

This is an important nuance to understand. Manually refreshing the dataset does not force Power BI to process its raw activity logs in real-time. There's still an internal lag between a user's action and that action being ready for collection. A successful manual refresh simply pulls in the latest data that has been processed by the service. So while the data will be much fresher than waiting 24 hours, it might still lag by an hour or so. Rest assured, you have the latest available data.

Pro Tip: Automate the Refresh Schedule

If you find yourself manually refreshing a specific usage report frequently, consider automating it. Since the usage report is backed by a standard Power BI dataset, you can set a custom refresh schedule for it.

1. Find the usage metrics dataset in your workspace list just as you did before.
2. Click the "..." (More options) menu for that dataset.
3. Select Settings.
4. Expand the Scheduled refresh section.
5. Here, you can set the dataset to refresh more frequently, up to 8 times per day on a shared capacity, or 48 times per day on a Premium capacity.

This is incredibly useful for high-priority reports where management wants to monitor adoption throughout the day, removing the need for repeated manual intervention.

Final Thoughts

Refreshing your Power BI usage metrics report is a straightforward process once you know the trick: you're not refreshing the report, but its underlying dataset. By locating the "Usage Metrics Report" dataset in your workspace, you can trigger a manual refresh to get faster insights into how your content is being used and adopted.

Constantly checking individual reports and manually refreshing data is a sign of a broader challenge many teams face - the struggle to get a unified view of performance without endless manual work. For that reason, we built tools to solve this very problem. With Graphed{:target="_blank" rel="noopener"}, we connect directly to your marketing and sales data sources, automating the entire pipeline. You can simply ask questions in plain English, like "show me our most popular reports alongside the campaign metrics that drive users to them," and get a live, unified dashboard in seconds, saving you from the busywork of clicking refresh buttons so you can focus on the actual insights.