Fuzzy matching required for exact match

[BenChain]

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?

[Anonymous]

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

[ERD]

Hi @BenChain ,

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