Forum Discussion
Merge Error
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 🙂
Hi Anonymous
You may not choose the appropriate column and merge method when performing Merge Queries, resulting in a Cartesian product, causing each combination to be executed again
When doing Merge Queries, you select the appropriate fields of the two tables and the appropriate connection method
If my answer is not what you need, can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.
Best Regards,
Liu Yang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.