Forum Discussion

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago

Issue with text column relationship in Power BI

Are you seeing any issue while establishing a relationship based on text columns? if the text contains space, special characters or with the case sensitivity    Please add your experience here.  
Need Help
Tips and Tricks
v-jiascu-msft's avatar
v-jiascu-msft
Icon for Microsoft Employee rankMicrosoft Employee
9 years ago

Sunkari

 

Hi,

 

Yeah, when creating relationships, Power BI ignore the space and the case sensitivity while Remove Duplicates doesn't. So we can't create relationships due to no column has unique values even we have removed the duplicates. Maybe a bug. We are working on it. What happened to special characters? (which ones)

 

Best Regards!

Dale 

 

 

Sunkari's avatar
Sunkari
Icon for Responsive Resident rankResponsive Resident
9 years ago

v-jiascu-msft: Thanks for the response. There is a bug with a text column relationship, I just wanted to bring your notice.

  • vanessafvg's avatar
    vanessafvg
    Icon for Community Champion rankCommunity Champion
    9 years ago

    power query is case sensitive and dax isn't so if you clean your data in power query sometimes it looks unique but when you try to link it the following creates issues

     

    1 any linking text columns that have different cases would look the same with relationships in dax, but power query would have seen it as unique, best thing to do is to change all the text to upper or lower case in power query

    2 any blank records also create issues in dax, pad empty / null values with a 'unknown' or something to resolve that issue