1-1 Relationship is showing values where they do not match

[SamCramphorn]

Hi,

I have a basic 1-1 relationship with a SQL DB and Salesforce object. The ID's are indentical.

However, when I link Table A (Company Details has 6 records) with Table B (Company Details as well which has 70k records)

It shows ALL data for Table B and Table A, whereas infact I just want the data which relates to them both.

The irony is that it works on another PBI report I have, but the DB is DirectQuery whereas this one isn't.

From this I then will link other tables into it, I do not want to merge. 

Thanks,

Sam

[amitchandak]

@SamCramphorn , Try to make it single-directional from A to B

or 1-m Single directional from A to B 

[SamCramphorn]

I tried that but I get the error:

'The filter direction you have selected isnt valid for this relationship'

Thanks