Power Query, not able to create a relationship saying duplicates but Duplicates /Blank rows dele

Hi Experts

I extracted a SQL two tables which are related 

Example: Each of the office may or may not be associated with a program 

Once I have the list, I wanted to create power query relationship

Fact table Office, Program 

Created copy to create unique office Dimension table  and Program Dimension table 

1. Copied the query table created from the fact table of office, program and deleted office to create Program as dimension data

2. Removed blanks, duplicates 

Was not able to make a relationship with fact table as it says duplicates. I could do it for dimension data of office linked to fact table. I used excel to check for duplicates, verified with conditional formatting and I also did trim and clean to ensure blanks are considered. 

Please can you give me idea. I have about 750 rows, is that a issue ?