Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
Anonymous
Not applicable

Merge issue

Hello, 

 

I can't seem to fix this issue, below.   I am positive that both fields are of the same type.   Any ideas what could be causing this?    Anything to do with the order of query editor steps?  

 

merge.jpg

4 REPLIES 4
v-jayw-msft
Community Support
Community Support

Hi @Anonymous ,

 

The information you provided is not enough, I can only find a topic with same issue with you, hope it helps.

https://community.powerbi.com/t5/Desktop/Merge-error-quot-we-were-unable-to-determine-how-many-matches/m-p/278584

 

Best Regards,

Jay

Community Support Team _ Jay
If this post helps, then please consider Accept it as the solution
to help the other members find it.
GlauberCaires
Advocate I
Advocate I

Hi,

Did you check if there is any null value in column or the data type is "ABC123" or the values in column arent distinct?

amitchandak
Super User
Super User

@Anonymous , Is this many to many join. If it giving OK button you can go ahead

Anonymous
Not applicable

No, on the Problem Codes table, the RMA_and_RMALine column is unique values.  

Helpful resources

Announcements
LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.