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
Jayadev's avatar
Jayadev
Icon for Helper I rankHelper I
8 years ago

Powerquery while extracting data showing the values as in the database, while loading to the model, it converts to upper case.

And relating table does not happen !!!

 

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
  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    Unfortunately, this did not surprise me when I encountered it.  MSFT's emphasis seems to be on pretty reporting, rather than focusing on the data engine.  There are a great many requests still outstanding, which ask them to fixi the data engine, and make it easier to manipulate the data.