Forum Discussion

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
7 years ago

Relationship text to text with trailing spaces

We have two tables in which technically they are unique values in the database on both ends. Please notice that one of them have a trailing space. Power BI does not allow me to create a relations...
General Comment
Need Help
PattemManohar's avatar
PattemManohar
Icon for Community Champion rankCommunity Champion
7 years ago

purnima13 Please try creating a unique hexadecimal value in the database (which will be unique for each text with space and without space) and use this as a relationship link between tables.

purnima13's avatar
purnima13
Icon for Helper I rankHelper I
7 years ago

PattemManohar Thank you. This is indeed a good idea.
Is there any way for it not to impact perfomance in the relationship?
A hexadecimal would be a text according to power BI and large text field have poor performance.

  • v-yulgu-msft's avatar
    v-yulgu-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    7 years ago

    Hi purnima13,

     

    I got below response from PG:

    When strings are imported into AS Engine, the trailing spaces are trimmed.

     

    It looks like currently we are not able to avoid this behavior. The workaround is to replace the trailing space with other type of character.

     

    Best regards,

    Yuliana Gu