Forum Discussion
Refresh failed - Column 'X' in Table 'Y' contains a duplicate value (This is a Invalid Error)
I have had a report that has been running on the PowerBI.com Service for many months using our on-premise gateway to access our SQL Server and until recently it has been running without issue, refres...
Hi everyone,
I am experiencing the same issue pulling data from an oracle database.
Everything is fine in pbi desktop, but as soon as I use incremental refresh in the service (for exactly the same data i.e. no changes in time dimension etc.) I get the error message related to duplicate values in a primary key column. Even after adding a step "remove duplicates" on the column on question (which is actually not necessary, because there cannot be duplicates in this column in the source) I keep getting this error.
Does anyone have any suggestions on how to tackle this?
Thanks in advance,
Nico