Get the refresh date & time in Power Query

[muhammad susanto]

hi all..

how to make the code working well

let
//Get the file path
    FilePathString = FilePath,

//Get length of file path
    FilePathLength = Text.Length(FilePathString),

//Get last slash position
LastSlash = Text.PositionOf(FilePathString,"\",Occurrence.Last),

//Get the folder path
FolderPath = Text.Start(FilePathString,LastSlash + 1),

//Get the file name
FileName = Text.End(FilePathString,FilePathLength - LastSlash - 1),

//Get the date modified
    DateModified = Folder.Contents(FolderPath){[Name=FileName]}[Date modified]

in
    DateModified

after running code show message

"Expression.Error: The import FilePath matches no exports. Did you miss a module reference?"

then Go Error
show message:
"Expression.Error: The name 'FilePath' wasn't recognized. Make sure it's spelled correctly"

how to fix the problem? please, give me correct new code

thanks

susant

 

[RoryA]

What is FilePath supposed to be in the first line after the Let? That is not a built-in function.

 

[muhammad susanto]

Hi..
I found the code in google, that's code no syntax error message when pasting into power query editor but after running the code not working properly

 

[RoryA]

Then you missed some code. There must have been another query/function called FilePath that returned the file path for the source workbook.

As an aside, that would actually return the date that one source file was modified, not the last refresh time of your query. Getting the latter is a lot simpler as you can just use DateTime.LocalNow in a query.

 

[muhammad susanto]

hi man, thank you but i really want to use the code like in this video link

but i don't know how to modify the code to make correctly

 

[RoryA]

Did you download the example file? In the video it clearly shows him creating a query called FilePath to return the path of the source file. That is what you are missing.

 

[muhammad susanto]

hi...

i will try it.