I have a problem i haven't been able to find the solution for.
I have a bunch of Excel files located throughout different folders. Each file pertain to a specific project, and have the same data structure. They all have a table on the first page with the same columns and a single row of data about the specific project.
To find the different Excel files i have created a "Master" Excel which have a table of all the file paths.
The idea is to use this "Master" in PBI to find all the Excel files, grab the rows of data and put them together in one table in PBI.
Then when a new project pops up, and a new Excel file is made, i can simply add the file path to the "Master" Excel and let it grab the new data and add it to the rest.
How would i go about doing this?
If you need more info let me know.