Forum Discussion
Solved
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...
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
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