get last date saved for excel file in power query

[ironpink]

hi all
in my work my colleagues update data in a excel file in a sharepoint folder (in this folder there's just one file).
so i need to show in powerbi report last update date and time of the excel file

I found on the web this way to get the info from the folder

But everytime the model updates, I get query error.

does anybody can show how get date and time of last update from the excel file (saved in a sharepoint folder)?

thank you

raffaele

[serpiva64 · Accepted solution]

Hi,

Try to remove Content column and it will function.

If this post isuseful to help you to solve your issue consider giving the post a thumbs up and accepting it as a solution !

[ironpink]

great

it works

[amitchandak]

@ironpink , In the source step are you seeing filename with time. Then you can add it while expanding.

Are you adding that has sharepoint folder?

example extension of this idea on sharepoint -https://community.powerbi.com/t5/Desktop/Show-date-last-saved-for-excel-file-source/m-p/281736