One source in the Excel data model

Occasional Visitor

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?

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...

Related Conversations
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
2 Replies
Early preview of Microsoft Edge group policies
Sean Lyndersay in Discussions on
65 Replies
*Updated 9/3* Syncing in Microsoft Edge Preview Channels
Elliot Kirk in Articles on
205 Replies