Forum Discussion
NewbieJono
Post Partisan
Post PartisanIncremental 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 imp...
ToddChitt
Super User
Super User"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.