Logging Historical Data From File in Folder

[sparkplug9375]

Hello,

I'm looking to stack historical data from a duplicated query. I turned refresh off for the query, but is it now possible when the other sheet is refreshed, the new data from the specific columns can be merged into it?

Thanks

[Nathaniel_C · Accepted solution]

@sparkplug9375 ,

Not sure if I totally understand your issue, but look into getting data from one folder.  Dropping your sheets into one folder and appending the new files.  @KenPuls  gives a great description of this in his book, M is for (Data) Monkey and it might be on his website.

If this solves your issues, please mark it as the solution, so that others can find it easily. Kudos are nice too.
Nathaniel

[sparkplug9375]

To clarify,

Say I keep the first file from a folder after each refresh. Is there a way to log that file in power bi without changing my loading options after each refresh?

IE a new report is published 9/26 then another on 9/30. Can this historic information be stacked on a seperate query while still only loading the first file?

Thanks