Gateway Dataset refresh fails on Duplicate value despite no duplicate or blank value present

[Anonymous]

Hello,

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.

Cluster URIWABI-AUSTRALIA-SOUTHEAST-redirect.analysis.windows.net

Activity ID1c51072d-dcdb-4a3c-b417-451d3c081f33

Request ID9d31965a-cf0d-93ac-551f-43baafb6dc30

Time2018-11-22 03:26:08Z

Thanks

[v-yuezhe-msft]

@lehuok,

Please update your gateway to latest version, then re-publish the PBIX file to Power BI Service.

If the error still occurs, change the relationship to many-to-many in PBIX file, then re-publish and refresh the data in Power BI Service.

Regards,
Lydia