Home

incremental refresh in query editor

%3CLINGO-SUB%20id%3D%22lingo-sub-433382%22%20slang%3D%22en-US%22%3Eincremental%20refresh%20in%20query%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-433382%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20using%20query%20editor%20in%20excel%20to%20pull%20raw%20data%20from%20multiple%20files%20within%20a%20folder%20that%20contains%20day%20to%20day%20data%20in%20it.%20I%20am%20experiencing%20a%26nbsp%3Blengthy%20waiting%20period%20when%20refreshing%20the%20query%2C%26nbsp%3Band%20each%20day%20the%20waiting%20time%20increases%20as%26nbsp%3Bit%20searching%20through%20more%26nbsp%3Band%20more%20files.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20setting%20that%20can%20be%20applied%2C%20or%20an%20approach%20to%20tell%20the%20query%20editor%20to%20only%20look%20for%20new%20files%2C%20as%20the%20previously%20loaded%20files%20will%20not%20change%20as%20they%20will%20be%20historical%20data.%20This%20way%20the%20refresh%20times%20will%20be%20fast%20as%20it%20will%20only%20be%20looking%20for%20a%20days%20or%202%20days%20worth%20of%20data%2C%20rather%20than%203%20months%20worth%2C%20or%20by%20the%20end%20of%20year%2C%2012%20months%20worth..%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-433382%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EPower%20BI%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
cchiappazzo
Occasional Visitor

I am using query editor in excel to pull raw data from multiple files within a folder that contains day to day data in it. I am experiencing a lengthy waiting period when refreshing the query, and each day the waiting time increases as it searching through more and more files.

 

Is there a setting that can be applied, or an approach to tell the query editor to only look for new files, as the previously loaded files will not change as they will be historical data. This way the refresh times will be fast as it will only be looking for a days or 2 days worth of data, rather than 3 months worth, or by the end of year, 12 months worth..

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies