Incremental refresh

[NewbieJono]

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

 

[NewbieJono]

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

[mahoneypat]

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

[ToddChitt]

"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.