I have a Power Query that's been generated to transform a bunch of data in Excel. I now need to apply this query across ~400 excel files. I'm trying to leverage some automation to complete this task rather than applying the query to each file manually. I have 3 questions if anyone is able to assist:
- The files have numerous tabs. A "Master" and then a tab for each month of the year. Is there a way to specify which tab to be used within the query?
- Likely related to the question above, each tab is just text entered into the worksheet, there are no tables. Is there a way to automate having a table added based on the correct tab selection, to then run the query?
- Is there a way to execute this Power Query across all ~400 files in bulk, as opposed to opening each one individually and pasting the query
Thanks