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.
4 Replies
- amitchandak
Super User
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
HamidBeeHi 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
Community Champion
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.
