How to Add Last Updated Date in Power BI

Nothing stalls a decision faster than uncertainty about your data. When a stakeholder looks at your Power BI report and asks, "Is this data from today?" your credibility hangs in the balance. One of the simplest and most effective ways to build user trust and clarify your data's freshness is to display the last updated date. This article will show you exactly how to add a dynamic, automatically updating 'Last Refreshed' timestamp to your Power BI reports.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Why Is a ‘Last Updated’ Date So Important?

Adding a refresh date to your report might seem like a small detail, but it has a significant impact on how users perceive and interact with your data. It’s a powerful feature that accomplishes several key things at once:

• Builds Trust and Confidence: When users can see precisely when the data was last pulled, they're more confident in basing their decisions on it. It removes ambiguity and shows transparency.
• Prevents Misinterpretation: A sales manager looking at last month's numbers needs to know they aren't looking at real-time data from this morning. A visible timestamp prevents costly mistakes based on outdated information.
• Reduces Trivial Questions: It stops the endless stream of emails and messages asking, "Hey, have you refreshed the report yet?" The answer is always right there on the screen.
• Improves Report Governance: It's a hallmark of a well-maintained and professional report, signaling to everyone that the data's lifecycle is being managed properly.

Now, let's get into the practical, step-by-step methods for adding this feature to your reports.

Method 1: The Quick-and-Dirty Manual Text Box

If you're creating a one-off report that won't be refreshed automatically, or you just need a placeholder quickly, the simplest method is to use a text box. However, keep in mind this is a manual method. It will not update automatically when you refresh your data. You have to edit it by hand every time.

How to Add a Manual Text Box:

1. In Power BI Desktop, navigate to the Insert tab on the ribbon.
2. Select Text box.
3. Type something like "Data as of April 15, 2024".
4. Position and format the text box to fit your report's design. You can change the font size, color, and background in the Format pane.

Again, this is only suitable for static reports. For the majority of business reporting needs, you’ll want a dynamic solution.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Method 2: The Automatic Last Refresh Date with Power Query and DAX

This is the standard and most reliable method for dynamically displaying the last refresh time. It works by using Power Query to create a small table that records the timestamp of each refresh, which you then display on your report. It's a "set it and forget it" solution.

Here’s the process at a high level:

1. Create a Query: Use the Power Query Editor to create a new query that captures the current date and time.
2. Load the Query: Load this new query into your data model as a separate table.
3. Create a Visual: Use a Card visual in the report to display this timestamp.
4. Format the Output (Optional DAX Measure): For ultimate control and cleaner formatting, write a simple DAX measure.

Let's walk through it step-by-step.

Step 1: Capture the Refresh Time in Power Query

First, we need to tell Power BI to grab the current time whenever a data refresh occurs.

1. On the Home ribbon in Power BI Desktop, click on Transform data. This will open the Power Query Editor.
2. In the Power Query Editor, go to the Home tab, click the New Source dropdown, and select Blank Query.
3. A new query will appear in the Queries list on the left. Right-click it and rename it to something descriptive, like LastRefreshTimestamp.
4. With your new query selected, click on Advanced Editor in the Home tab.
5. Delete the existing template text and paste in the following M code. This code snippet gets the current time in the Coordinated Universal Time (UTC) standard, which is best practice for data refreshed in the Power BI Service.

let
   Source = DateTimeZone.UtcNow()
in
   Source

1. Click Done. You'll see a single value showing the current date and time.
2. We need to convert this single value into a table. On the Transform tab, click the To Table button. A small dialog box will pop up, just click OK without changing any settings.
3. Power Query will rename the first column Column1. Rename it to Last Refreshed, then click the icon next to the column name to change its data type to Date/Time/Timezone. This ensures it is displayed correctly on your dashboard.
4. Finally, on the Home tab, click Close & Apply to load this new table into your data model.

A Note on Time Zones

We used DateTimeZone.UtcNow() because it's the safest option. When you schedule refreshes in the Power BI Service, they run on servers that operate in UTC. Using UTC ensures consistency. If you want to convert this to a specific local time zone, you can modify the M code. For example, to convert to Eastern Standard Time (UTC-5):

let
   Source = DateTimeZone.SwitchZone(DateTimeZone.UtcNow(), -5)
in
   Source

Remember to select the Date/Time/Timezone data type when using formulas that deal with timezone offsets on Power Query, ensuring that the final time is displayed correctly with its corresponding time zone.

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 2: Display the Refresh Date in Your Report

Now that the timestamp is in our data model, we can add it to the report canvas.

Option A: Use the Field Directly in a Card

The fastest way to display your data is using these steps for a basic approach:

1. From the Visualizations pane, add a Card visual to the page.
2. In the Data pane, find your LastRefreshTimestamp table and drag the Last Refreshed field onto the “Fields” well of the card.

The Card visual will show the raw date and time. Adjust the format of this date on the Format your visual icon while selecting the visual. Look under Callout Value to find your formatting options under Values.

Option B: Create a Formatted DAX Measure

For more control and to add clarifying text, a DAX measure is far more elegant. Use its result on the aforementioned Card visual, and since we pre-append the "Last Refresh date: " text, it provides users clear context that they are looking at a timestamp of your report’s freshness.

1. Right-click on your LastRefreshTimestamp table and select New Measure.
2. The DAX formula bar will appear. Enter the following formula:

Last Updated Label = "Last Refreshed: " & FORMAT(MAX('LastRefreshTimestamp'[Last Refreshed]), "mmmm d, yyyy \a\t h:mm AM/PM")

1. Place a Card visual with your new Last Updated Label, and you’re all set! Here's the final look:

The format code inside the formula can be personalized for full dates, only hours in military format, and more. Here’s a cheatsheet based on codes in our main formula:

Graphed

Still Building Reports Manually?

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

Watch the Demo

Step 3: Test and Publish

The final step is testing it on your Power BI Desktop to ensure smooth operation before publishing.

Testing on Desktop

On Power BI Desktop, testing is as simple as going to the Home tab and clicking the Refresh button. This simulates a data refresh, and your card with the date/time should immediately update with the refreshed timestamp.

Using it on the Service

Once your dashboard is polished, publish it into your business team’s Power BI service site. From this site, you can configure a refresh schedule as needed. Check if your new label works by going to Workspace → Your Dataset → Settings. Set Schedule refresh as needed, and you’ll see the last modified stamp updating automatically.

Final Thoughts

Adding a dynamic "last refreshed" timestamp is a small but powerful refinement that elevates the professionalism and reliability of your Power BI reports. By using a simple Power Query script and a display visual, you ensure that anyone viewing your data knows exactly how current it is, fostering trust and enabling them to make better, more informed decisions.

We know these little tweaks that separate a good report from a game-changing one can take time to master, whether it's learning Power Query quirks or writing the perfect DAX formula. At Graphed, we handle that friction for you. Simply connect your data sources like Google Analytics, HubSpot, or Shopify, and create entire dashboards using conversational language. All our dashboards are real-time, pulling in live data so you're never guessing if the information is stale. It's the simplest way to get to the answer without getting stuck on setup and configuration details.