Forum Discussion
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.
Thanks in advance for your support
4 Replies
It cannot help to solve the issue.
Any suggestions bout it ?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
