Forum Discussion
Sunkari
Responsive Resident
Responsive ResidentIssue 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.
SunkariResponsive Resident
Responsive Residentv-jiascu-msft: Thanks for the response. There is a bug with a text column relationship, I just wanted to bring your notice.
vanessafvg
Community Champion
Community Championpower 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