Forum Discussion
Power ParticipantIssue with Merging Tables
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.
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.
