Forum Discussion

NewbieJono's avatar
NewbieJono
Post Partisan
4 years ago

Incremental refresh

Hello all, 

 

is there any benifit of setting up Incremental refresh on an excel file saved in sharepoint. a warning pops up saying the query does not fold.

 

also if is set it up to only import the last 7 days of data, can i sometimes ovewrite this and preform a complete refresh e.g if i have to change data further back. if so how can this be done.

 

thanks in advance

 

Need Help

3 Replies

  • ToddChitt's avatar
    ToddChitt
    Super User
    4 years ago

    "Folding" refers to pushing data operations such as WHERE, GROUP BY etc. down to the database server level. SQL Server and other RDBMS can handle it. Excel, CSV, and SharePoint do not support "query folding".

    Sorry.

  • mahoneypat's avatar
    mahoneypat
    Microsoft Employee
    4 years ago

    Yes, you can benefit from incremental refresh when combining files too. If you filter the create/modified dates (or parse the date from the filenames and convert to date) with the RangeStart and RangeEnd parameters before you pull the data/process each file, you can save a lot of time on each refresh.

     

    Below is an example (I played with this recently):

    Pat

     

  • NewbieJono's avatar
    NewbieJono
    Post Partisan
    4 years ago

    how would i force a full refresh of the data if i enable incrmental refresh