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...