Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Compete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.

Reply
a_yang
Frequent Visitor

Display Last Refresh Date with New Data

Hello,

 

How can I display the last refresh data when there is new data? I found this formula but it gives me the date everytime the dashboard refreshes, I have it automatically refreshing a couple times a week. It refreshes using a file that is automatically generated which my dashboard pulls from. We want to know if that file for some reason fails to be generated, that we are still running on old data. 

"let
Source = #table(type table[Date Last Refreshed=datetime], {{DateTime.LocalNow()}})
in
Source"

 

Example, on 1/1/22 my file is automatically generated and my dashboard refreshes, it will show last updated: 1/1/22.

On 1/2/22 there is an error and my file does not automatically generate or rewrite over the old file, my dashboard still refreshes using the old data and shows that the data was refreshed on 1/2/22, when actually it's just old data. So because it's old data I want the card to show 1/1/22 even though it technically refreshed, it has old data. This would help be an indicator of when my file is not automatically generated. 

Is there any way for me to have a card that shows the last time there was new data uploaded and refreshed?

I'm sorry if this is confusing!

Thank you,

Ally

1 ACCEPTED SOLUTION
edhans
Super User
Super User

No. You have two options:

But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting

View solution in original post

3 REPLIES 3
Daryl-Lynch-Bzy
Resident Rockstar
Resident Rockstar

@a_yang - The first thing that occurs to me is that when Power BI Dataset refreshes, if there is an error loading data today, the previous Dataset is not replaced.  Effective, when you view the Report/Dashboards you will see the old data, but also the Last Refreshed datetime would not have been replaced.  The Power BI dataset refresh needs to replace all objects.  It won't replace the Last Refresh date if it can't load another object.

The second thing that occurs to me is that it might be possible to using an API to refresh individual objects in Power BI.  This could refresh the Data table, check for successful change and then refresh the Last Refreshed object.  This is an advanced refresh option that requires Premium Capacity.

edhans
Super User
Super User

No. You have two options:

But when Power BI Refreshes, it doesn't check to see if anything changed, it assumes it all changes on refresh.



Did I answer your question? Mark my post as a solution!
Did my answers help arrive at a solution? Give it a kudos by clicking the Thumbs Up!

DAX is for Analysis. Power Query is for Data Modeling


Proud to be a Super User!

MCSA: BI Reporting
a_yang
Frequent Visitor

Thank you!

Helpful resources

Announcements
August Power BI Update Carousel

Power BI Monthly Update - August 2025

Check out the August 2025 Power BI update to learn about new features.

August 2025 community update carousel

Fabric Community Update - August 2025

Find out what's new and trending in the Fabric community.

Top Solution Authors