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
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 PhilipTreacy
I managed to figure it out a second before your reply. 😄
I was having trouble getting the data that i wanted, but that was simply an error within the Excel files, which i fixed.
Thanks for your help!!
What if those Excel files have multiple sheets, how to correctly add the sheet name to the path?
