Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I never had this error before while refresh but today I had this error-
My data source is from a custom connector by the warehouse management system guys.
Solved! Go to Solution.
Hey @learner03 ,
did you refresh the preview and set column profiling to the whole data set?:
From my experience, Power Query is sometimes a little buggy with the display, so maybe check in the data source if there is a duplicate row.
Also mark the ID column and just add as last step to remove duplicates. Like this, the error should be solved:
Hey @learner03 ,
the error message says it already, you have a duplicate value in your table. And as you have a 1:m relationship this is not allowed on your 1 side.
Delete the duplicate value in your data source or in Power Query and the error will disappear.
I search for this ITemID in the table and it gave me just one line-
and the relatinship is as below-
Hey @learner03 ,
did you refresh the preview and set column profiling to the whole data set?:
From my experience, Power Query is sometimes a little buggy with the display, so maybe check in the data source if there is a duplicate row.
Also mark the ID column and just add as last step to remove duplicates. Like this, the error should be solved:
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
65 |
User | Count |
---|---|
136 | |
118 | |
101 | |
71 | |
61 |