Unknown duplicate error when refreshing XMLA dataset

(0) Share

Report

Posted on by mhamiltonMAG

Hi, I get this error when refreshing the dataset, but I know that there are no duplicates in the source tables. The load is supposed to load incrementally using a refresh policy.

Error

Column 'customer_id' in Table 'Reservation Customer' contains a duplicate value '41293623' 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.

I saw other posts that mention to delete the join, but then I need the join to exist?

I am importing into the Power BI service and can only modify the dataset in Tabular Editor.

I was able to load the tables individually using SSMS but then it fails when using the Power BI service refresh option for the whole dataset.

Mark

Categories:

Issue