Power Query Self Appending Queries
Power Query Self Appending Query
I've built a few self appending Power Queries by modifying the M in advanced editor - It would be nice to have the functionality built into the GUI.
The Query would read the loaded query data from the related ListObject (or data model) into memory while asynchronously querying another data source. The data from the other data source would be append to the previously loaded data set then either load the table or load back to the data model after removing duplicates(optional).
Jerry Norbury commented
You can already make a self appending query without using the advanced editor.
There's only 1 part of the entire process which requires some trivial manual entry in the formula bar redirecting the Source = to a different query.
plz add power query in excel 2016 mac
Steven Watson Buehler commented
I'd like to see the code you wrote for this, I'm looking for a way to do looped/cursored queries with Power Query and your code may come in handy.