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

Bibiano_Geraldo's avatar
Bibiano_Geraldo
Super User
1 year ago

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.

Anonymous's avatar
Anonymous
Not applicable
1 year ago

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
    Source

 

  • Bibiano_Geraldo's avatar
    Bibiano_Geraldo
    Super User
    1 year ago

    It seems that there's no problem with code, its possible to share no sensiitive file to see the problem closer?