Append Query

[Anonymous]

Is anyone else having issues with appending queries?  I have tried multiple times and it doesn't appear to append my queries as designed.  We have been having some issues with Power BI lately and wondering if this is another bug.

[j_ocean]

In what way is it not working as designed?

Column names not matching is the main thing that goes wrong with appends. 

[lbendlin]

Define "goes wrong".  If the column names don't match then the append will work shifted.

[j_ocean]

"Work shifted" when you wanted non-shifted is not working. Or, "gone wrong," as one might say.

This is the most common problem precisely because it does run without throwing errors--it's easy to stumble in to and lacking a warning you could be a dozen steps down the line before an aggreation or some logic gives you answers that cannot be in the real world.

Its all speculation until and unless the OP tells us some more details of the expected vs actual results.

[Anonymous]

Hi @Anonymous 

When you use the append query, you need to ensure that:

1. The column name aomong the tables need to be the same

2.The count of the  columns among the tables need to be the same

Please check your data if your data is meet the requirement above, you can refer to the following link.

Append queries - Power Query | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[lbendlin]

@Anonymous neither of the points you mentioned are required.

[lbendlin]

Not really.  Can you show some sample code?  Are you using the standard functions or the shorthands?