Forum Discussion
Anonymous
6 years agoNot applicable
Missing Data After Combine Files
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 di...
v-piga-msft
6 years agoResident Rockstar
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