Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
I need to merge two tables together. But it keep saying "we were unable to determine how many matches the selection will return".
The merge was working before, so i don't know what is the problem now. If a click accept anyway, then it returns me this message:
The columns i been trying to merge has the same type of data and everything.
Please help
Hi, @devfrogmi
I wonder if you made some changes in the source data(modified the table name or clumn names). Power BI doesn't recognize the changes so that the merge failed. You may try updating the source data or modify the query for corresponding transformations which refer to the changes.
Best Regards
Allan
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Have the tables transformed in any way before the merge ?
Be aware that merge uses the last version of reference table.
The tables are not transformed in any way. Besides, the merge was working before and nothing changed.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.