Have you ever thought, how can we let the user know how stale your data is in the report?
In this blog, we will see how to add a last refreshed date in the Power BI report. Even this can also be used to see your automatic refresh is working fine or not.
Let’s get started…
Step 1: Open Power BI desktop, click on Transform Data option.
Step 2: From the Home ribbon, click in New Source option and select Blank Query.
Step 3: Once you have Blank Query table “Query1” in place under the Queries section, right click on it and rename it to “Last Refreshed Date”.
Step 4: Now, open the Advance Editor from the Home ribbon and paste the below M code.
M Code
let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source
Once you pasted the code, click on Done.
Now, the M code will create a column with name “Last Refreshed Date” which has current date and time. This date will get updated every time you refresh the dataset of the report.
Now, click on Close & Apply.
To show last refreshed date you can either use a card or a text box depending on the space you have.
This is all about adding a last update date detail on your report.
I hope you will find this blog helpful.
Gaurav Lakhotia
Data Analyst
Addend Analytics
PrevPreviousUsing Images in Power BI – Slicers/Axis/Conditional Formatting
NextNULLs in SQL ServerNextSearch
Recent Posts
Categories
Have you ever thought, how can we let the user know how stale your data is in the report?
In this blog, we will see how to add a last refreshed date in the Power BI report. Even this can also be used to see your automatic refresh is working fine or not.
Let’s get started…
Step 1: Open Power BI desktop, click on Transform Data option.
Step 2: From the Home ribbon, click in New Source option and select Blank Query.
Step 3: Once you have Blank Query table “Query1” in place under the Queries section, right click on it and rename it to “Last Refreshed Date”.
Step 4: Now, open the Advance Editor from the Home ribbon and paste the below M code.
M Code
let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source
Once you pasted the code, click on Done.
Now, the M code will create a column with name “Last Refreshed Date” which has current date and time. This date will get updated every time you refresh the dataset of the report.
Now, click on Close & Apply.
To show last refreshed date you can either use a card or a text box depending on the space you have.
This is all about adding a last update date detail on your report.
I hope you will find this blog helpful.
Gaurav Lakhotia
Data Analyst
Addend Analytics
Author By
Kamal Sharma
Kamal brings over 20 years of experience in data analytics and business intelligence. He has led the design and implementation of analytics solutions across operations, financial reporting, and performance improvement initiatives. With a background in business statistics and Six Sigma, his work focuses on applying data in a structured and practical way to solve real business challenges.
