Forum Discussion
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 append it creates extra blank columns and many extra rows. I should only have 44 extra rows but it is creating 746 extra rows. Any ideas what I am doing wrong or another way to add these 44 rows to the Table A?
Thanks!
4 Replies
hello, inorder to append , the column names should be exactly identical and case sensitive
moreover if it persist please share some screenshots without sharing sensitive data you can blur the rowshmm thats odd, try those:
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.
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.
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.
Hi Anonymous ,
'I should only have 44 extra rows but it is creating 746 extra rows'
This is really strange, but sometimes excel loads additional rows and columns if the excel is not clean enough.
I would suggest to load Table A and Table B individually and ensure that the you receive the desired output. Once the individual tables are correct then you can append one over the other.I hope you're able to get to the root cause and solve the issue.
Please mark it as answer if it resolves your issue. Kudos are also appreciated.
Regards
Vibhor
