cvs file modified date and last refreshed date

[u4us1923]

I imported almost 70 csv to the PowerQuery. After imported I modified those csv files in PowerQuery and have a big table from those csv files. Every week those csv files are change.

First of all every week I move those csv files to under the relevant folders and then update all data with the "Refresh All" button. But, I want to make sure that all the data is updated. Checking one by one is really a waste of time. I want to see the date of the relevant cvs files and the last refresh date to a column. is it possible?

Thank you in advanced .. 

[marcosvin · Accepted solution]

Hello!

To search for information from the CSV file such as the modification date, you can create a query in Power Query by selecting the option "Get Data" > "From Folder" and select the desired CSV file. This will display a table with the columns of information for each file (as shown in the image below).

To create a column from the last Power BI refresh, you can create a calculated column using the DateTime.LocalNow() function.

References:

https://community.fabric.microsoft.com/t5/Desktop/Create-a-date-custom-column-by-file-date/m-p/10638... https://gorilla.bi/power-query/last-refresh-datetime/