Forum Discussion
Append Query Not Working Properly
Hi, I am trying to append these three example tables using Append Queries and it appears there's an issue as PBI is not appending all StoreID's into the same column. Table 1 StoreID Salesper...
Disregard my previous messages. I just realized that I had two versions of the StoreId column name. One as StoreID and other as StoreId. This has been causing the wrong append.
I also looked at some other posts that suggested creating duplicate tables and creating the same order of columns and removing unwanted columns before appending the datasets. I did this and the append still didn't append the data correctly.
Here is a screenshot with StoreID data type
Disregard my previous messages. I just realized that I had two versions of the StoreId column name. One as StoreID and other as StoreId. This has been causing the wrong append.