Forum Discussion
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 imp...
"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.