Forum Discussion
Merge Error
I am trying to merge a two data sets have 75000 (approx) & 45000 rows, however, i get over a million rows in merged query , How it is happening, i am preplexed. i used full row merge
Please refer this article: https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-shape-and-combine-data
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂
Anonymous
When you merge use the right key combination and expand only the required columns. Without those right column keys, you may get a cross join effect.
Also, filter out the unnecessary rows before the merge.
________________________
If my answer was helpful, please consider Accept it as the solution to help the other members find it
Click on the Thumbs-Up icon if you like this reply 🙂