on 26 Jul 2016 13:11:29
My data read from a folder. Everyday I will put in a new file into the folder and when click refresh it will refresh all file in the folder which is time consuming. Can we have an option to "refresh only new file".
The process of "refresh only new data" will be:
1) Any last modified file: based on modified date and changed name (so that it wont confuse as new file)
2) Any newly included file
- Comments (28)
RE: Refresh only New Data or Modified File in Folder
Me too
RE: Refresh only New Data or Modified File in Folder
As much as I would like to link my PowerBi to an online or SQL data source, I can't. So I have to rely on downloading the data to Excel Files first. With every additional week the refresh takes longer and longer. Please, Microsoft, include this in the features!
RE: Refresh only New Data or Modified File in Folder
'I agree with Nicolas P and would like a functionality that would enable Power BI to consider new and updated files only, since thew last Refresh.
Example (Date Format DD.MM.YYYY):
- Power BI: Last Refresh Finish Timestamp: 03.10.2018 @09:00:00
- Excel file1: Last Updated Timestamp: 16.09.2018 @15:30:00 > Do not import file
- Excel file2: Last Updated Timestamp: 04.10.2018 @08:15:00 > Import file (and "crush" the corresponding data already imported into Power BI during the last refresh)
- Excel file3: New File posted 03.10.2018 @20:30:00 > Import file
RE: Refresh only New Data or Modified File in Folder
Interesting why only 14 votes on this CRUCIAL function.
Leaving aside the fact that the designers / programmers / developers from Microsoft have not thought about it from the beginning ...
40 minutes refresh every day is not funny... I need it...
RE: Refresh only New Data or Modified File in Folder
Yes, Every customer ask this function. it would be excellent.
RE: Refresh only New Data or Modified File in Folder
I really need this function, cause, the old files dont change, i only need to update the last file or the last modified file. Updating the rest of the files, it onbly makes the update more slow.
RE: Refresh only New Data or Modified File in Folder
Me too!
RE: Refresh only New Data or Modified File in Folder
Yes, I would love this functionality