Skip to main content

    Power BI

    Needs Votes

    Refresh only New Data or Modified File in Folder

    Vote (225) Share
    's profile image

    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 (36)
    's profile image Profile Picture

    Timothy Monnin on 16 Dec 2022 15:18:48

    RE: Refresh only New Data or Modified File in Folder

    Agree this would be good to have out of the box.In the mean time, try the incremental refresh as described here:https://www.thepoweruser.com/2020/01/19/incremental-refresh-for-files-in-a-folder-or-sharepoint-power-bi/

    's profile image Profile Picture

    Zane Sierra on 20 Oct 2022 14:22:54

    RE: Refresh only New Data or Modified File in Folder

    This functionality would be ideal!

    's profile image Profile Picture

    Loren Ray on 31 Jan 2022 16:24:20

    RE: Refresh only New Data or Modified File in Folder

    We produce daily Excel spreadsheets that contain 5-10MB of data each. My historical data WILL NOT change. I need a means of refreshing with the prior days data WITHOUT having to refresh all of my historical data. Please implement!

    's profile image Profile Picture

    Chris B on 26 Nov 2021 16:12:10

    RE: Refresh only New Data or Modified File in Folder

    This is a must have function. Power query pulls data from 70 Excel files save by business units (BUs). That data is review by management. Some BUs may be required to modify data in their files. Power query needs to incorporate data from all files, but needs to refresh only for modified files. This would be a great time saver.

    's profile image Profile Picture

    Alain Volan on 09 Sep 2021 11:36:22

    RE: Refresh only New Data or Modified File in Folder

    A must!

    's profile image Profile Picture

    Alvin Ryell Prada on 28 Jul 2021 02:49:52

    RE: Refresh only New Data or Modified File in Folder

    Please add this functionality

    's profile image Profile Picture

    James Walker on 16 Apr 2021 18:25:27

    RE: Refresh only New Data or Modified File in Folder

    Would be very useful

    's profile image Profile Picture

    Matt White on 05 Mar 2021 09:40:50

    RE: Refresh only New Data or Modified File in Folder

    Honestly, I've spent hours trying to figure out how to use incremental refresh with file modified, because I assumed that such an obvious use case MUST work.

    's profile image Profile Picture

    Power BI User on 07 Sep 2020 08:37:25

    RE: Refresh only New Data or Modified File in Folder

    This seems like a must for any user that is using Power BI to its full potential.

    's profile image Profile Picture

    Richard Williams on 16 Aug 2020 04:20:19

    RE: Refresh only New Data or Modified File in Folder

    Must add!