Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

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 t...
Need Help
  • Anonymous's avatar
    Anonymous
    1 year ago

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

danextian's avatar
danextian
Super User
1 year ago

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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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!