How to append .txt File in power BI? And refresh only the yearly files.

[pavithra_viki]

Consider 2017 file as below:

2017.txt

Install: 9 August, 2017 0:24 Window: XP User: 1234 MS Office: 2019
Install: 10 August, 2017 1:24 Window: 7 User: 4235 MS Office: 2017
Install: 11 August, 2017 2:24 Window: 7 User: 64563 MS Office: 2019
Install: 12 August, 2017 3:24 Window: XP User: 74563 MS Office: 2019
Install: 13 August, 2017 4:24 Window: XP User: 85674 MS Office: 2019
Install: 14 August, 2017 5:24 Window: XP User: 7456 MS Office: 2022
Install: 15 August, 2017 6:24 Window: 7 User: 234 MS Office: 2019
Install: 16 August, 2017 7:24 Window: XP User: 856 MS Office: 2018


Consider 2016 file as below:

Install: 8 December, 2016 9:24 Window: XP User: 1234 MS Office: 2019
Install: 9 December, 2016 10:24 Window: XP User: 4235 MS Office: 2019
Install: 10 December, 2016 11:24 Window: XP User: 64563 MS Office: 2019
Install: 11 December, 2016 12:24 Window: XP User: 74563 MS Office: 2019
Install: 12 December, 2016 13:24 Window: XP User: 85674 MS Office: 2019
Install: 13 December, 2016 14:24 Window: XP User: 7456 MS Office: 2022
Install: 14 December, 2016 15:24 Window: XP User: 234 MS Office: 2019
Install: 15 December, 2016 16:24 Window: XP User: 856 MS Office: 2018



Case:
I need to append these two file i.e., 2016 and 2017 file into single file.
In future if 2018 file is coming in, I need to load only 2018 file into power bi,, Like wise 2019 , etc (Loading recent year into power bi)
Problem :
It is a txt file. 
The file is not having the header part, I need to include Header and append. 


Kindly help me.

[v-heq-msft · Accepted solution]

Hi @pavithra_viki ,

Based on your description, you can try the following steps:
1.Put all your txt files in the same folder and then get data from folder

2.Choose the target folder and combine and transform them

3.Choose the delimiter as space and click ok

4.In the power query, you can do data cleaning, such as merge column 2,3,4,5 and change type as Date/Time and you can also rename the column as you want

5.If you have other new file, put in the same folder and refresh preview or you can process desktop refresh

Best regards,
Albert He

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