Forum Discussion
Syndicate_Admin
Administrator
AdministratorOriginal date Source file
Good morning I have a PowerBi that is powered by an excel file, *.xlsx, that file is uploaded every week, but it is not automatic But I need the date of that file to come out in the PowerBi to know...
danextian
Super User
Super User
Is the date in the file name? If yes, that can be extracted using some Text functions. Otherwise, you need to use either the Folder or SharePoint Folder connector depending on where your file is stored to get a files metadata. You can use the modified column.
Note: this approach isn't foolproof as if the file is stored in SharePoint and somebody opens it, the modified date might change as well.
Syndicate_AdminAdministrator
AdministratorIf correct, the date is the one in the file
It would be too much to ask, how to get it?
Thank you
- danextian
By the one in the file, you mean the date is in the filename?