You’re offline. This is a read only version of the page.
Announcements
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
Share
Report
All responses (
Answers (
796
