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

[Anonymous]

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 ?

[Anonymous]

Hi @Anonymous ,

See the video: Building relationships between tables when both have duplicates - YouTube

Or check the similar post:  Solved: Can´t create a relationship between two columns be... - Microsoft Power BI Community

In short that one of the table has unique product numbers and then there won't be any issue.

Best Regards,

Stephen Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[latimeria · Accepted solution]

Hi mythbusternz,

Powerquery is case sensitive, dax not.

You have no dupicates row in powerquery while there are duplicates in DAX.

User parameter Comparer.OrdinalIgnoreCase or make sure to have same cases ( all upper, First Capitalised, ..)