Forum Discussion

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago
Solved

Incremental data load from Excel

If I'm not mistaken this is not yet available, with that... - does it mean that I have to maintain all my historical files locally(or wherever they are currently located)? - does that mean that if ...
Need Help
  • MattAllington's avatar
    MattAllington
    9 years ago

    There are a few approaches. Read my blog series starting here. http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/

     

    I believe you can load a table and then disable refresh. I have never tried it but I assume you should be able to load a history file (say years 2014 -2016) and not refresh them  on reload - you would need to test it 

     

    Upload order is not important. 

MattAllington's avatar
MattAllington
Community Champion
9 years ago

There are a few approaches. Read my blog series starting here. http://exceleratorbi.com.au/combine-excel-workbooks-power-query-method-1/

 

I believe you can load a table and then disable refresh. I have never tried it but I assume you should be able to load a history file (say years 2014 -2016) and not refresh them  on reload - you would need to test it 

 

Upload order is not important. 

ovetteabejuela's avatar
ovetteabejuela
Impactful Individual
9 years ago

Thanks again MattAllington, your recommendations are enough to flag this as solved! I'll take your word for it... but I will test and get back to this post what I have discovered.

 

Thanks for the link as well, I will read through it (learn from it).