Forum Discussion
Can't set relation 1:*
- 5 years ago
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 , 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....