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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
Rusciano
Frequent Visitor

Collecting each refresh date.time in a table

Hi Community,

 

I am about losing my head to solve the following issue. It would be very easy for members which usually use Power.Query but not for me that a never do it before (I have always used DAX !!!). 

 

I computed a very simple query = DateTime.LocalNow() in order to retrieve the last update data time. By clicking on "Refresh" button the date time update correctly, putting the data.time in a calculated table with one column. Thus, the issue is that the query overwrite the previous record: not adding a new row for each refresh, not collecling the dates in the column but overwriting the date. 

 

Consequently, when I refersh the query does not add a new row recording the updated data time but it only overwrite the last data time record update.

 

To be clearer my issue is to have one column with how many rows as the refreshes are

 

Rusciano_1-1671441118068.png

Thanks in advance for your support

 

3 REPLIES 3
MianAhsan
Helper I
Helper I

@Rusciano , did you find a solution to collect each refresh date in a table? I'm facing a similar issue and looking for suggestions/solutions. 

Rusciano
Frequent Visitor

It cannot help to solve the issue.


Any suggestions bout it ?

amitchandak
Super User
Super User

@Rusciano , Check if this method can help

https://blog.crossjoin.co.uk/2020/04/13/keep-the-existing-data-in-your-power-bi-dataset-and-add-new-...

Full Power BI Video 20 Hours YouTube
Microsoft Fabric Series 60+ Videos YouTube
Microsoft Fabric Hindi End to End YouTube

Helpful resources

Announcements
Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!