Forum Discussion
cvs file modified date and last refreshed date
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 ..
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/106386 https://gorilla.bi/power-query/last-refresh-datetime/
1 Reply
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/106386 https://gorilla.bi/power-query/last-refresh-datetime/