cancel
Showing results for 
Search instead for 
Did you mean: 

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

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
Status: Needs Info
Comments
v-yuezhe-msft
Microsoft

@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

v-yuezhe-msft
Microsoft
Status changed to: Needs Info