Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

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...
Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
1 year ago

No, I was referring to the properties of the file

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    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 Zhou

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.