Text File Data Source - Append rather than replace

[Smnhrt]

I have 7 text files to use as source data, I want to append the data rather than replacing the data so that I have 'Test_Portfolio_Policies2' comprising of the 7 text files.

Of course, in future, this data source can be made of any number of text files, so I would want to know how to append multiple text files together when changing data source rather than replacing the data source.

(Unfortunately, I cannot ask the client to simply combine multiple text files together)

[v-chenwuz-msft]

Hi @Smnhrt ,

Did you get your problem solved? If so, please mark it and anyone with the same problem as you will find this post quickly.

If not, you can refer this article for more detail steps about how to combine multiple files.

Combine files (binaries) in Power BI Desktop - Power BI | Microsoft Docs

Best Regards

Community Support Team _ chenwu zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak · Accepted solution]

@Smnhrt , if you want to change connection, you can use change Source and you have to do that.

The best solution can be to put these files in a folder and add them as a folder and try to append folder files (Try folder option)