cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
PaulDBrown Established Member
Established Member

Relationship error when trying to create lookup table: need help desperately!

Hello everyone,

 

This has been driving me completely crazy over the weekend. I am trying to create a several lookup tables from the source fact table: all the lookup tables are created by way of "reference" to the original fact table in the query editor. the idea is to create a tree from lowest to highest granularity so that when filtering from the top, the subsequent slicers get in turn filtered down etc..

 

when trying to create the relationship from one of the tables to the next I get this error:

Relationship error dragging.PNG

 

The thing is the table I have create to link down a step I have "removed duplicates":

Barrio duplicates.PNG

 

And if I try to create the relationship manually I'm  still getting the message saying that one of the tables has to have unique values:
Error relationship manual.PNG

 

So what is going on here? I desperately need to get on with this project, and I'm stuck at the moment.

 

Thanks for your help,

 

Paul. 

1 ACCEPTED SOLUTION

Accepted Solutions
kriscoupe Regular Visitor
Regular Visitor

Re: Relationship error when trying to create lookup table: need help desperately!

Hi @PaulDBrown,

 

To my knowledge you at you cannot create case sensitive relationships within Power BI. In your table Nombre De Barrio on lines 4 and 10 you have les corts and Les Corts. When removing duplicate Power BI trets these as different but.. when creating relationships these are the same. This thread may provide more info

 

https://community.powerbi.com/t5/Desktop/Creating-Case-Sensitive-Table-Relationships/td-p/18210

 

Hope this helps.

 

Regards,

Kris

3 REPLIES 3
kriscoupe Regular Visitor
Regular Visitor

Re: Relationship error when trying to create lookup table: need help desperately!

Hi @PaulDBrown,

 

To my knowledge you at you cannot create case sensitive relationships within Power BI. In your table Nombre De Barrio on lines 4 and 10 you have les corts and Les Corts. When removing duplicate Power BI trets these as different but.. when creating relationships these are the same. This thread may provide more info

 

https://community.powerbi.com/t5/Desktop/Creating-Case-Sensitive-Table-Relationships/td-p/18210

 

Hope this helps.

 

Regards,

Kris

PaulDBrown Established Member
Established Member

Re: Relationship error when trying to create lookup table: need help desperately!

@kriscoupe

 

Thank you! well spotted!!

 

Though I can't begin to understand the logic behind why removing duplicates treats them as the different values, but then treats them as one if trying to create a relationship. It kind of defeats the prupose of "removing duplicates" if the end result is that there is a conflict (I mean, if what we are trying to do is create a lookup table for example, shouldn't the integrity of upper/lower case be kept when creating a relationship?- that would help in the clean-up process...). 

 

Anyway, at least I can move on, which is what I desperately needed...

And seeing this behaviour I have now opted to include a step entailing "create uppercase for each word" or something to that effect...

 

Thanks again,

Regards,

 

Paul.

Figaro67 Regular Visitor
Regular Visitor

Re: Relationship error when trying to create lookup table: need help desperately!

Combine and load error.png

I have three excel files, workbooks and I choose Folder, then Combine and Load and I get this error.