Missing Data After Combine Files

[Anonymous]

Hi everyone,

I have one problem. I got data of in excel sheets for 2017 (Jan-Dec) & 2018 (Jan-Dec). So total Excel files are 24 files with the same column header (Date, Product Name, Amount). I did use the feature in Power Bi to combine all those files by using "Get Data >> Folder". After successfully combine all the data, I found that the data in column Amount for 2017 have gone missing but column Amount for 2018 has no problem. Meaning, in column header Amount year 2017, all stated "Null" which originally have their own values.

I did try combine files only for 2017 (12 files) and 2018 (12 files) separately, and it works. All the data were there. However when I try to combine all 24 files, it went missing.

My question is why does it happen? Is that because of the "Date" conflict that makes the values in Amount column for 2017 gone missing? Why Power Bi only take the data of later year (2018) but not both of year (2017 & 2018)  

[v-piga-msft]

Hi @Anonymous ,

Have you solved your problem?

If you have solved, please always accept the replies making sense as solution to your question so that people who may have the same question can get the solution directly.

If you still need help, feel free to ask.

Best  Regards,

Cherry

[v-piga-msft]

Hi @Anonymous ,

By my tests, I cannot reproduce your issue by combining the files in power bi.

Normally, the issue should be caused by the different column headers.

Are you sure the column names are the same for the files?

If it is convenient, could you share the screeshots or the data sample so that we could have a test on it?

Best  Regards,

Cherry