Hello.
Is there any formula to get the last update date of a file ?
I get the data from PQ and work on it to insert graphs in an excel dashboard. I want to insert the date of the files I am retrieving, which will return when was the last successful refresh done.
Is that possible without involving VBA ?
Thanks, Bruno.
Hi Bruno,
You can create a blank query with this code from ExcelGuru.ca:
let
Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})
in
Source
Close & Load this to a table in your workbook which you can link to from your dashboard.
Mynda
Thanks for your quick answer.
I am afraid I didn't understand you. I know how to create a new query, when I create it I can paste that code but then when closing I get a strange string (= "let#(cr)#(lf)#(cr)#(lf)Source = #table(type table[LastRefresh=datetime], {{DateTime.LocalNow()}})#(cr)#(lf)#(cr)#(lf)in#(cr)#(lf)#(cr)#(lf)Source")
And how do I connect that to a specific database I download?
Bruno
Hi Bruno,
The #(cr) etc. aren't in my code. That's being imported when you copy and paste it from the forum web page to Power Query. I recommend you type the query out or copy and paste it into Notepad or similar and then copy it from there to see if that prevents the extra characters being pasted.
Mynda
