cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
MidnaJazz08
Frequent Visitor

Fecha de ultima actualizacion del Dataset / Dataset last updated date

¡Hola amigos!

 

Necesito saber cómo puedo obtener la última fecha de actualización de mi conjunto de datos, esto se actualiza automáticamente todos los días a las 09 am, pero en mi informe tengo la última actualización de Power BI Desktop.

 

Intenté con esta publicación (https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/) pero no funciona.

********************************************************************

Hi friends!

 

I need to know, how can I get the last updated date of my dataset, this is automatically updated everyday at 09 am, but in my report I have the last updated of Power BI Desktop.

 

I try wtih this post (https://www.excelguru.ca/blog/2016/06/08/display-last-refreshed-date-in-power-bi/) but doesn't work.

 

Thanks for your help!

 

MidnaJazz08_0-1633322296335.png

Should says 03/10/2021 09:15 / Debería decir 03/10/2021 09:15

1 ACCEPTED SOLUTION
v-yalanwu-msft
Community Support
Community Support

Hi, @MidnaJazz08 ;

Please try it .

Method1: add custom column in power query .

 

=DateTimeZone.FixedLocalNow()

 

vyalanwumsft_0-1633498159917.png

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

 

Method 2:create a blank query 

vyalanwumsft_1-1633498261663.png

 

= DateTime.LocalNow()

 

then convert to table.

vyalanwumsft_2-1633498292977.png

https://askgarth.com/blog/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

The final output is shown below:

vyalanwumsft_3-1633498346902.png

 

https://community.powerbi.com/t5/Desktop/Automatically-adding-date-for-last-refresh-of-data/td-p/751...Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

2 REPLIES 2
v-yalanwu-msft
Community Support
Community Support

Hi, @MidnaJazz08 ;

Please try it .

Method1: add custom column in power query .

 

=DateTimeZone.FixedLocalNow()

 

vyalanwumsft_0-1633498159917.png

https://docs.microsoft.com/en-us/azure/devops/report/powerbi/add-last-refresh-time?view=azure-devops

 

Method 2:create a blank query 

vyalanwumsft_1-1633498261663.png

 

= DateTime.LocalNow()

 

then convert to table.

vyalanwumsft_2-1633498292977.png

https://askgarth.com/blog/how-to-add-the-last-refreshed-date-and-time-to-a-power-bi-report/

The final output is shown below:

vyalanwumsft_3-1633498346902.png

 

https://community.powerbi.com/t5/Desktop/Automatically-adding-date-for-last-refresh-of-data/td-p/751...Best Regards,
Community Support Team_ Yalan Wu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

View solution in original post

lbendlin
Super User
Super User

The last refresh date is often meaningless. Power BI will happily refresh stale data over and over again.  The only true indicator of the freshness of the data has to come from inside of the data. Ideally a "Last Modified Date"  field. That's what you want to rely on, and display it on all your report pages.

Helpful resources

Announcements
UG GA Amplification 768x460.png

Launching new user group features

Learn how to create your own user groups today!

November Power BI Update 768x460.png

Check it Out!

Click here to read more about the November 2021 Updates!

M365 768x460.jpg

Microsoft 365 Collaboration Conference | December 7–9, 2021

Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.

Top Kudoed Authors