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.
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.