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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

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
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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

April Fabric Community Update

Fabric Community Update - April 2024

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