Forum Discussion
Multiple Excel files, with multiple tabs
Hi I have a daily system generated Excel file which is saved in a single folder. Each file has multiple tabs (Data, Data1, Data2, etc) as the system caps the data reflected on each tab to 65,535...
Many ways to do this. I would aggregate the tables within Excel so each file has one powerquery output answer.
Data > Get Data > From other sources > Table / Range
(For sure make sure things are real tables)
You simply don't do that step for the summary ones.
You can then within PowerQuery append all theses tables easily with the user interface
Then in your PBIX file you only need to make one connection per file - the answer table you created from appending. Hopefully that is a managble!. There are many other options.