Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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 c...
Need Help
  • Nathaniel_C's avatar
    Nathaniel_C
    6 years ago

    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

Nathaniel_C's avatar
Nathaniel_C
Community Champion
6 years ago

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

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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