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
paffa88's avatar
paffa88
Regular Visitor
8 years ago

This is really a weird and messy issue.

 

Honestly, i could not understand how is it possible that MS didnt fix it yet,

We built a complex architecture and BI solution and now during the final testing we discovered that basically do not work due to many keys recognized as the same one.

Why, if the DB (SQL Server) and Power Query are case sensitive, is there in the middle a piece that is case insensitive? i could not really understand.

 

Did you find any solution meanwhile? At the moment we are adding space at the end for the duplicate key but this is just a workaround.

Js29's avatar
Js29
Frequent Visitor
8 years ago

I have the same issue, salesforce uses case sensitive text IDs and power bi does not honor those in relationships

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    When you bring your IDs into Power BI, simply change them into a single case, such as upper case.

    • Js29's avatar
      Js29
      Frequent Visitor
      8 years ago
      Not an option, the ids are real valid case sensitive ids.
      I have sales force tables with more than 15M records...
      We have more than 2k licenses, i will open a support big