Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
given
Regular Visitor

Append Query

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.

6 REPLIES 6
j_ocean
Helper V
Helper V

In what way is it not working as designed?

 

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

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

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

v-xinruzhu-msft
Community Support
Community Support

Hi @given 

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.

@v-xinruzhu-msft neither of the points you mentioned are required.

lbendlin
Super User
Super User

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors