Forum Discussion
One source in the Excel data model
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?
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-94b8023c-2e66-4f6b-8c78-6a00041c90e4
1 Reply
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-94b8023c-2e66-4f6b-8c78-6a00041c90e4