Forum Discussion
Logging Historical Data From File in Folder
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
Anonymous ,
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
2 Replies
- Nathaniel_C
Community Champion
Anonymous ,
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.
NathanielTo 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