Forum Discussion
Append Queries Broken?
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,
Yang
Community Support TeamIf 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
9 Replies
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,
Yang
Community Support TeamIf 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
Hi, Anonymous
Based on the above information, It's a reproducible issue. Due to the new reply policy, I would suggest opening a Support Ticket.
If you are a Power BI Pro or Fabric licensee, you can create a support ticket for free and a dedicated Microsoft engineer will come to solve the problem for you.
It would be great if you continue to share in this issue to help others with similar problems after you know the root cause or solution.The link of Power BI Support: Support | Microsoft Power BI
For how to create a support ticket, please refer to How to create a support ticket in Power BI - Microsoft Power BI Community
Best Regards,
Yang
Community Support Team
Hi Anonymous ,
Please double check your applied steps to see if is there some step that filter out the new data to be added.
if possible, share with us the M code by going to advanced editor, is not easy to say withou see or interacting the problem.Or try to append as new query to see if the problem persist.
Hi Bibiano, I've stripped the applied steps down to just the basics in terms of aligning the data types and renaming the headers for the fields that I want to combine. I'm using the 'Append Queries' functionality on the ribbon to combine the two tables.
I've never had issues with this in the past. This is about as basic as it gets. Here is the code it produces:
let Source = Table.Combine({#"FCST Import", Actuals}) in SourceIt seems that there's no problem with code, its possible to share no sensiitive file to see the problem closer?
Hi Anonymous
It is possible that after the append step, there are filter steps that remove the data from the second table. Check for any applied steps labeled 'Filtered Rows.' These are most likely just applicable to the first table.
Thanks for the reply danextian, no filters are applied after the append. I pasted the code in reply to bibian_geraldo below. Based on Yang's response it looks like this is a replicable bug with large data sets. Thanks again!
