cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
BenChain
Frequent Visitor

Fuzzy matching required for exact match

Hi

 

I have 2 tables. Table A has a relationship with Table B using an ID in the standard way.

 

Lets' say both have 150 rows and it's a 1:1 relationship.

 

When I do a direct query in SQL 

 

SELECT *
  FROM [dbo].[A]
LEFT JOIN [dbo].[B] ON B.Id = A.BsID
 
I get the results expected: 150 rows
 
When I do merge queries in powerbi... I only get a match of 125 out of 150. I check fuzzy match and I get 150. 
 
What is PQ reading to differentiate my data that an SQL query directly on the DB does not? Or is this just an issue with the preview?
2 REPLIES 2
Rocco_sprmnt21
Super User II
Super User II

could you, at least, upload the id's involved?

 

 

ERD
Responsive Resident
Responsive Resident

Hi @BenChain ,

Here is a nice article on Fuzzy Matching in Power BI and Power Query .

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

secondImage

Are You Ready?

Test your skills now with the Cloud Skills Challenge.

Top Solution Authors