Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

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 relationshi...
Need Help
  • latimeria's avatar
    latimeria
    4 years ago

    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, ..)

     

Anonymous's avatar
Anonymous
Not applicable
4 years ago

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.