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