Fecha de ultima actualizacion del Dataset / Dataset last updated date

[MidnaJazz08]

¡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!

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

[v-yalanwu-msft · Accepted solution]

Hi, @MidnaJazz08 ;

Please try it .

Method1: add custom column in power query .

=DateTimeZone.FixedLocalNow()

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

Method 2:create a blank query 

= DateTime.LocalNow()

then convert to table.

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

The final output is shown below:

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

[lbendlin]

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.