Hello,
I would like to write a query in powerquery that will allow me to import data to excel several times and create one table for Poland from this. The links are in the "links" sheet, the current query in the "EIOPA" worksheet (it is a query that imports a zip file from the page, then unzips it and selects one excel file and one sheet from it -> actually with this I also have a slight problem, because despite the definition of links as "paths" the query does not want to download data, if you insert a link on the basis of copy paste, everything works okay). The expected result is importing data for Poland from the links specified in the "links" sheet and compiling it all together, which is more or less visible in the "Expected result" sheet. I know that this can be done somehow from the "List.generate" function, but I do not know how to use it in this case. It would be the best if the function worked until it encounted an empty cell.
Thank You in advance
Bookmarks