Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

PBI Desktop Append Queries

I have one file in transform data from SQL (Table A) and another in Excel format (Table B).  I am attempting to append (not append new) as there are measures already written in Table A.  When I appen...
Need Help
Anonymous's avatar
Anonymous
Not applicable
2 years ago

Thank you!

columns names are identical... I wonder what else it could be?

 

 

and 

Table B

 

 

 

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    2 years ago

    hmm thats odd, try those:

    1. Ensure Consistent Column Names:

      • Make sure that the columns in Table A and Table B have the same names and data types, especially for the columns that you want to append.

    2. Clean Up Data:

      • Before appending, ensure that both tables are cleaned up and contain only the necessary data.
      • Check for any empty rows or columns in both Table A and Table B and remove them.

    3. Data Types and Transformations:

      • Verify that the data types of corresponding columns in both tables are compatible. If needed, apply data type conversions or transformations to make them match.