Forum Discussion
Original 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 if it is really updated with new data
Thank you
5 Replies
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.
If correct, the date is the one in the file
It would be too much to ask, how to get it?
Thank you
By the one in the file, you mean the date is in the filename?
No, I was referring to the properties of the file
Hi Syndicate_Admin ,
I suggest you to move the excel to a folder and then connect to the folder as well.
For example, here is a table from excel.
I connect to the folder as well, then we will get data in below format.
I think you can check the data modfied column from this table as danextian mentioned before.
Due to Power BI is a read only application, it will only load the latest data modfied date after refresh. It will not keep the last modified date before. You may need to record the last modified date manually.
Best Regards,
Rico ZhouIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
