Issue with text column relationship in Power BI

I had the same issue.

I have a column in two different tables with text.  These "text" columns should have identical values. Therefore I should be able to make a "One to Many" releationship between the tables.  

After Upercasing all text and removing empties, I still could not get a visiual to show me data from one table based on the text column of the first table.  When I make the relationship, there is no error. It supposedly works as a "One to Many".  Nonetheless, visiuals do not see any relationship. It is as if, the data was completly unique in the related columns of the two tables.

So I copied the columns to a spreadsheet and compared (vlookup).  That work as expected. I have matches. I do not know why Powerbi doesn't see ANY of the related values.

So I made a work around.

In Power Query, on both tables I created a new column based on the columns I want to relate.  On those new columns I replaced, Quotes, Question marks and spaces with nothing (left the field empty).

I updated the relationship to use the new columns, which now look like VERYLONGGERMAN words (no spaces). 😉

Now my visuals work.