Collecting each refresh date.time in a table

[Rusciano]

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. 

Thanks in advance for your support

[ONGCHEESENG]

Hi,

Achieved the same goal. But by using Power Query in Excel. May be inspired you and happened in your Power BI as well.

https://youtube.com/shorts/V2ut7MnvNCo?feature=share 

BR

ONG CHEE SENG

//M Codes
let
    Source = List.RemoveNulls(Excel.CurrentWorkbook(){[Name="Table1_1"]}[Content][Refresh Date n Time]&{DateTime.LocalNow()}),
    Custom1 = #table(type table [Refresh Date n Time=datetime], List.Transform(Source, each {DateTime.From(_)}))
in
    Custom1

[MianAhsan]

@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]

It cannot help to solve the issue.

Any suggestions bout it ?

[amitchandak]

@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-...