Forum Discussion
Get data from multiple Excel files using the file path as parameter
Hi Anonymous
What I meant was that the Master file you created will have a list of the files you want to load data from, something like this
Create a table from this data (CTRL+T) then load into Power Query/Power BI. Add a custom column like this
which will give you the contents of each file in that new column (as tables) like so
You can then expand these tables (click on the double haeded arrow in the header) and extract the data you want.
Regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Hi Anonymous
Load the Master table of file paths/names into Power Query.
Add a Custom Column with the following
= Excel.Workbook(File.Contents([Filepath]), null, true))
This will load the contents of the files into a new column. Expand/transform the files as needed.
regards
Phil
If I answered your question please mark my post as the solution.
If my answer helped solve your problem, give it a kudos by clicking on the Thumbs Up.
Hi PhilipTreacy
I'm afraid i dont entirely understand what you mean by loading the table into Power Query.
Could you elaborate a bit? 🙂