Forum Discussion
incremental refresh in query editor
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 ea...
I was just researching this question. As you apparently know, there is a dedicated feature in PowerBI for incremental refresh.
.
There is not a similar feature in Excel PowerQuery. But I did find a couple of articles that suggest manual work arounds
Incremental data loads in Microsoft Power Query for Excel (DIY incremental) 2015 05 15
https://www.oraylis.de/blog/incremental-data-loads-in-microsoft-power-query-for-excel
How to create a Load History or Load Log in Power Query or Power BI 2016 11 19
https://www.thebiccountant.com/2016/02/09/how-to-create-a-load-history-or-load-log-in-power-query-or-power-bi/
IMHO, that's more about incremental data appending, not about incremental refresh
