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%3CLINGO-SUB%20id%3D%22lingo-sub-1068342%22%20slang%3D%22de-DE%22%3ESubject%3A%20incremental%20refresh%20in%20query%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1068342%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F318937%22%20target%3D%22_blank%22%3E%40cchiappazzo%3C%2FA%3E%20could%20you%20solve%20this%3F%20I%20have%20the%20same%20problem.%20Regards%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1068358%22%20slang%3D%22en-US%22%3EBetreff%3A%20incremental%20refresh%20in%20query%20editor%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1068358%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F490379%22%20target%3D%22_blank%22%3E%40hwoe1%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EI%20guess%20incremental%20refresh%20works%20only%20in%20Power%20BI%20Premium%2C%20not%20in%20Excel.%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
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..

2 Replies
Highlighted

@cchiappazzo could you solve this? I have the same problem. Regards

Highlighted

@hwoe1 

I guess incremental refresh works only in Power BI Premium, not in Excel.