Gateway Dataset refresh fails on Duplicate value despite no duplicate or blank value present
Submitted byAnonymouson11-21-201807:44 PM
today, one of my published datasets with Gateway Refresh schedule started failing on the error listed below.
However, when downloading the PBIX and opening in Power BI desktop (latest November 2018), refresh is fine.
I have also checked for Duplicate or blank values on either side of the relationship in the model (there is only one relationship), as well as in the database, and no duplicates or blanks (nulls) were found. Please advice.
Gateway is July 2018 version, and this dataset was refreshing fine until today.
There was an error when processing the data in the dataset. Please try again later or contact support. If you contact support, please provide these details.
Data source errorColumn 'Dut Id' in Table 'Batch Summary' contains a duplicate value '4059' and this is not allowed for columns on the one side of a many-to-one relationship or for columns that are used as the primary key of a table. Table: Batch Summary.