none
Overwriting/ Replacing Values in a Query with Another Query RRS feed

  • Question

  • Hi,

    I am currently struggling with finding the solution to a very important problem that would save me TONS!

    I have Excel files that are updated every week, but in different files with different names. I was thinking to import each file as their own query and somehow overwrite the old data with the newly updated data into one single query.

    Is it possible to overwrite one query onto another query in Power Query?

    Thanks in advance!

    Monday, April 23, 2018 2:47 AM

Answers

  • If all of the Excel files are in a single folder, then in Excel you can do Data-->Get Data-->From File-->From Folder. There are several online examples of consolidating multiple Excel files from a folder using Power Query.

    Monday, April 23, 2018 2:00 PM