Hello, I'm trying to append two tables, one is roughly 6,000 rows the other is 12,000. The append adds the data from the first query and includes the column headers from the second but none of the data from the second query is included. I've tried recreating the query several times. I've tried saving, quitting, restarting. I'm at a complete loss. Any help will be much appreciated.

Hi, Anonymous Thanks for the reply from danextian and Bibiano_Geraldo. When the amount of data in the two tables is too much there seems to be a problem that the data can not be displayed properly in the first place (the amount of data I am using here is about 70,000 rows, AdventureWorks2012.bak download link), and when appended as a new table, as shown below, the data can not be displayed properly. As a workaround, you can change the order of any of the columns to display the data. Best Regards,YangCommunity Support Team If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly.If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot! How to get your questions answered quickly -- How to provide sample data in the Power BI Forum

Append Queries Broken? | Microsoft Fabric Community

Forum Discussion

Related content

Dataflow - Append

Append Queries 3 different data sources

Append Queries and Remove Duplicate

Append query vs Append query as New

Appended queries not refreshing in service anymore