Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

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?
Need Help