Power pivot relationship problem

[ahmedismailfourtex]

Hello
I had created table using power query then I loaded to datamdule when I started to create relationship it said I have duoblications then I go back to power query and removed the dublications after that power pivot give the same message. and no dublications.
How to solve? ?

 

[olivierhbh]

Hello,

Which version of Excel are you using? Did you refresh your query in Power Pivot?

Olivier.

 

[ahmedismailfourtex]

yes man i was refreshed and i have excel 2013 up to date with power query up to date
do u have idea about that ?

 

[Ozeroth]

Is the 'lookup' column (that you are creating the relationship on) type text?

Power Pivot ignores case when checking for duplicates, while Power Query is case sensitive.
Suggested solution here:
Create a Dimension Table with Power Query: Avoid the case sensitivity bug! – The BIccountant

 

[ahmedismailfourtex]

Yes, it's text
I will check your link
Thanks ☺

 

[scottsen]

I will say that... in my years of using Power Pivot (where I have seen various bugs...)... I have never seen this be wrong. If Power Pivot says you have dupes, you have dupes.

I typically just add a measure TheCount := COUNTROWS(MyTable). Create a pivot table with TheCount in values, and my unique field (primary key) on rows. Sort by TheCount descending... and see what is going on. Often is is BLANK()s that will get you.