Forum Discussion
Formatting Column and Data
In a data file that I have brought into powerbi, one particular column/field is 98% made up of 5 or 6 numbers, and the balance is made up of a combination of numbers and letters, like this - DS2-1328...
That field is necessarily a text field. Which is okay unto itself. But then to join to the other table it must be a text type field as well - so this data type mismatch could be the culprit.
In SQL we can do a many to many join but in a Power BI app I believe for the join you want 1 table that has only unique values. So if in both of your two tables the values do repeat - then you need to create a reference table. Then you join both tables to that.