Forum Discussion
Solved
Power Query - How to Change Data Source and Use Same Queries
Hello, I am using Power Query in Excel and I'm new to the function so apologies if this is very straightforward. I have multiple budget workbooks that have different names but the sheets are all...
Are all your spreadsheets in the same exact format?
If so, you can use the from folder, and combine all the files.
Good link on this approach: https://www.youtube.com/watch?v=4fFL7Ok7Ovg
I agree with BKirsch12 that you probably want a Folder query here. But, if that is not what you are looking for, then you could create a query that just pulls in the data and does no other steps. Then, you would create your queries and reference that query. That way, you could just change the one query and all of your other queries would be pointing to the correct data source.