Use a list of excel files (from hyperlinks) as data sources

[amalm]

I have a list of files in the following format: 

This list is dynamic and there may be new ones added at any time. I want to import the data from all these excel files into Power Query. How can I do this?

[Jimmy801]

hello @amalm 

use this paths as table, add a new column where you place a formula that reads all data sources of type "sheet" and merge them. Afterwards expand the created table

If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too

Have fun

Jimmy

[StefanoGrimaldi · Accepted solution]

you can create a binary list quer and use it as parameters for a looping apis call: 

check this forum topic about that exact issue: 

https://community.powerbi.com/t5/Desktop/Looping-through-Parameters-for-API-calling/m-p/574796 

if this helped mark as solution for others to find it easily and give some kudos.