Forum Discussion
cvs file modified date and last refreshed date
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/
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/