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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
szielinski
Frequent Visitor

Data Refresh Field

hi im having a little isssue is that im trying of out a field on my dashboard that show me the last time i update the data

im look in several forums even here and videos that show a supossedly way to do it but is fake, what make those functions is just put a time stamp of the date of my sistem no of my tables 

this are some of the ways that i already try 

Add last refresh date to a Power BI report - Azure DevOps | Microsoft Docs

or go to the power query editor and put datetime code the but that dont reflect for real the last time i update my data that i want is this info, if someone can give me the rigth answer please

szielinski_0-1632865187468.png

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

the "Last refreshed"  data has not a lot of meaning. All it means that the Power BI service has successfully refreshed the partitions, but it has no idea if the data in the partitions is actually updated.  It will happily refresh old data over and over.

 

Find  a suitable datetime field in your actual data (like the last order date) and use that instead.

View solution in original post

1 REPLY 1
lbendlin
Super User
Super User

the "Last refreshed"  data has not a lot of meaning. All it means that the Power BI service has successfully refreshed the partitions, but it has no idea if the data in the partitions is actually updated.  It will happily refresh old data over and over.

 

Find  a suitable datetime field in your actual data (like the last order date) and use that instead.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

July Newsletter

Fabric Community Update - July 2024

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