Forum Discussion
Values in double but they're not
I found the answer : i had 2 types of data in the same column, text and number. Somehow, it was causing the error.
By carefully putting only text type earlier in the requests, it solved the problem.
It doesn't fully seem logic though (either it should be able to compare text and numbers, either should not, but what i had....... strange).
Anyway, solved... for now.
I found the answer : i had 2 types of data in the same column, text and number. Somehow, it was causing the error.
By carefully putting only text type earlier in the requests, it solved the problem.
It doesn't fully seem logic though (either it should be able to compare text and numbers, either should not, but what i had....... strange).
Anyway, solved... for now.
Hi Anonymous ,
Glad to see you solved your problem, it will be helpful for other users with similar issues. In power bi there will only be one datatype in a column, and as you've encountered, when creating a relationship you need to make sure that the datatypes of the two columns are the same. You can confirm this by looking at the properties of the columns in the power query or in the table interface.Best regards,
Albert He