Forum Discussion
Can't set relation 1:*
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 (
) 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
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.
3 Replies
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.
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....
