Issue with Merging Tables

[HamidBee]

I have two tables. I am trying to merge them based on a matching column. Please see below:

 

It matches 7000+ rows but only merges to form 1000. I am absolutely baffled as to why this is. Does power BI capped merged tables on a 1000. The number seems really specific.

Any help would be greatly appreciated.

Sidenote:

When I tried to merge the tables using inner join I get the following error above.

 

 

[amitchandak]

@HamidBee , In power query it show only 1000 rows , once you scroll and get more rows.

You should get all rows once you apply the changes

[HamidBee]

Hi Amit. Yes you are right. Power Query limits the merged rows to 1000. I find that strange. But there is an option on the bottom left of Power Query I have found which allows me to view all the rows.

 

Regarding the last issue, what would be the solution for this:

 Thank you.

[aj1973 · Accepted solution]

Hi @HamidBee 

W52 is not a number. You need to go back to the column W52 is and render the format of that column to TEXT. there is incompatibility issue between the 2 tables you are merging/appending. the best practice before merging is to delete all "Change type" in Query steps of each Table, Make sure all columns have the same format in both tables, do the merge/append then Change Type of the columns of the new table as desired.

[HamidBee]

Nice. Thank you for clarifying this for me. I've been stuck on it for ages. I thought W52 was an acronym for a specific type of error.