Forum Discussion

kzwyers's avatar
kzwyers
Frequent Visitor
8 years ago
Solved

Append Queries not bringing data from extra column

I'm having an issue where, when I try to append two queries, the additional column from the second query is in the combined query, but all records are null.   For example:   Query A: ID         ...
  • kzwyers's avatar
    kzwyers
    8 years ago

    Thanks all for your help, but I think I've figured it out.  The append is actually working.  It's just that the preview isn't showing all records (the actual tables are much larger than what my example shows).  I'm new to PowerBI, and didn't realize that this was due to the preview.

     

    Thanks again for your help!

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Hi

 

I tried to reproduce your error , but getting the right data only.

 

 

Are you sure you are have the right data i nthe table?

 

Thanks
Raj

kzwyers's avatar
kzwyers
Frequent Visitor
8 years ago

I do have more information on this issue.  When I do the append, the extra column is null for all records.  When I click on the down arrow button for the column, and then click on "Load More", then I see all values show up.  But, once I click on OK, it referts back to the column being null for all records.

 

However, if, immediately after clicking on "Load More", I filter on any one value, that value will be visible.  But, as soon as I choose "Select All", they all go back to null again.

  • kzwyers's avatar
    kzwyers
    Frequent Visitor
    8 years ago

    Thanks all for your help, but I think I've figured it out.  The append is actually working.  It's just that the preview isn't showing all records (the actual tables are much larger than what my example shows).  I'm new to PowerBI, and didn't realize that this was due to the preview.

     

    Thanks again for your help!