Source Community: Power BI Spanish | Source Author Name: franperalta84
Hello! Necessary help to bring the last modified date of an Excel file.
The table doesn't have a specific column that brings that data, but I'd like to take it from the modification of that file as shown in the carpet image.
Thank you!
1 ACCEPTED SOLUTION
Hi @Syndicate_Admin ,
I’d like to acknowledge the valuable input provided by the @Ritaf1983 . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
In my investigation, I took the following steps:
1. You can put the Excel file into a folder and select the folder data source in Power BI Desktop to connect. Then select Transform Data to enter Power Query Editor.
2. After filtering the required files, click the Combine Files button above the column name and select the required table.
3. The Power Query Editor will then automatically perform some steps. You can select the setting next to the removed other columns1 step and select the columns to keep.
4. The subsequent Change Type step may report an error. You can delete it and manually modify the field type.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Syndicate_Admin ,
I’d like to acknowledge the valuable input provided by the @Ritaf1983 . Their initial ideas were instrumental in guiding my approach. However, I noticed that further details were needed to fully understand the issue.
In my investigation, I took the following steps:
1. You can put the Excel file into a folder and select the folder data source in Power BI Desktop to connect. Then select Transform Data to enter Power Query Editor.
2. After filtering the required files, click the Combine Files button above the column name and select the required table.
3. The Power Query Editor will then automatically perform some steps. You can select the setting next to the removed other columns1 step and select the columns to keep.
4. The subsequent Change Type step may report an error. You can delete it and manually modify the field type.
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Please refer to the linked video guide:
https://www.youtube.com/watch?v=pHDRKNjuwmU
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
Source Community: Power BI Spanish | Source Author Name: franperalta84
Hello, thank you for your reply. From what I understand from the video, it would take the last updated date of any file in that folder where the excel in question is. In my case the folder where "the excel" is, has different excel files and not all the uses for my pbi. Following the example of the video I would take the last update of any of the excels and not of "the excel". I don't know if I make myself understood. Best regards.-
