One source in the Excel data model

[JonasM]

I'm getting data in one text-file for each year from an external source.

The structure in the files are the same for each file.

I want to use these files as one source in Excel.

One way I tried to use is to merge the textfiles into one and "connect" to the data with a query in Excel. The problem is to handle new data.
I want to be able to, instead of merging the files, merge the data into one source in the Excel data model but how do I accomplish this?

[#2]

You may use Power Query From Folder connector to combine all your files dynamically https://support.office.com/en-us/article/combine-files-in-a-folder-with-combine-binaries-power-query...