Forum Discussion
Values in double but they're not
Good afternoon,
Power BI is driving me crazy : it says i got values in double in a table (and so, i cannot make a 1-* relationship) while it's wrong.
Proof : in the error message, it says value 4134 is in double in my table. If i filter on this value, i only got 1 line with it. If i make a relationship with my new table only having 1 line, the 4134 one, it can be a 1-* relationship. Then, if i remove the Power Query filter, it does the same error again on 4134.
If i remove the line with 4134, the error appears on another value, which also is not in double.
(should i add : i removed the multiples values already before in my queries)
What can cause that, please ?
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.
2 Replies
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