Append queries not working correctly

[LeGoat]

Hi everyone, 

I appeneded 2 queries together and it shows the new table in the query editor and it shows both the tables data that I merged in the new table, but when I go to my report the second tables data is not transferring over to my table on my report. My table in my report shows all the data from the first table I merged but nothing from the second table. When I make a filter it shows both tables data, but when I filter it to the second tables data the table goes blank and as I said it shows nothing from the second table I merged into the new query. 

Sorry if this sounds a bit confusing let me know if I can provide anymore information to help understand better. 

Thanks, 

[Anonymous]

@LeGoat 
Check out this step by step tutorial for append. 
https://radacad.com/append-vs-merge-in-power-bi-and-power-query

It looks like the table is not successfully appended, I tested with append with my sample worked properly. Maybe you can explain with some image to describe your model.

Paul Zheng _ Community Support Team
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
 

[amitchandak]

@LeGoat , In append, I am assuming you would have done like this select Table1  and append with Table2. merge both in Table1.

Now check that the columns merged into the same expected columns. Because sometimes if there is a small diff in column names it will create new columns. So check the column names.

[HotChilli · Accepted solution]

If you can see all the data in the Data view, that would suggest the Append' has worked correctly.  Can you confirm this please?

"When I make a filter it shows both tables data, but when I filter it to the second tables data the table goes blank" -> this suggests that the filter on the second table is not doing what you expect it to do.  

Here are some options:

Attach the pbix and I'm sure someone can sort it for you reasonably quickly.

and/or

Investigate why the filtering of the second table is not working.  This could be some data anomaly (hidden characters etc).  What kind of filtering are you using? What's the data type involved?

You could try filtering in Data view using the column dropdowns to experiment.   You could post pictures of the filtering to show us what works and what doesn't.