Can't set relation 1:*

[epica81]

Hi, 

I tried to search on the comunity, I fonund a lot of suggestion but I can't find a real solutions.

I need to set a relation 1:* between 2 tables, but the application told me i can't and set it many to many.

I try to detect if there was error on  the table, or duplicated value.

This is the colum statistic: 

But If i try to manage a distinctcount (

DISTINCTCOUNT(ART_CODE[Code])

) of the column it returned 1658.

If I manage a distinct of that column from SQL, It returned 1659 elements, so what duplicate find PowerBI???

I try to search the duplicate on the defined colum but i can't find IT, and i'm sure there isn't inside.

Have you any suggestions?

Thanks

[amitchandak · Accepted solution]

@epica81 , check for any blank/null value in Code, because power bi does not allow that on the one side.

if not, put code and count of code in a table visual and sort desc on the count and check for any row > 1.

[epica81]

@amitchandak  I found the double code... you was right....

Thank you very much.

[epica81]

Hi Amitchandak,

I tried to find null/blank value, but I didn't find any row, I tried too to find a duplicated code but there aren't.

I really don't know if the problem is some special caracter on the code that give this error evaluation on powerbi side, on SQL side I didn't find a double code and can manage the join 1 to many, but I want to find a solution of this issue on PowerBi....