I am trying to refresh a Power Query data source which has a CSV file data source in it I've properly set up the DMG and confirmed that it works on a different workbook. I cannot get this workfbook to refresh, though. I get one of two errors, depending
on if I check all of the data sources to refresh or just refresh one at a time.
1) Check all data sources:
Sorry, something went wrong. Please try again. Correlation ID: d4e3867f-782d-4cc0-ac16-e044a701604d
2) Only check one data source:
Failure Correlation ID: 03975f7e-f51a-40c2-b95f-720fdd3c2e84
Column 'DoctorKey' in Table 'DoctorDirectory' contains a duplicate value '[Binary]' 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. The current operation
was cancelled because another operation in the transaction failed.
I have confirmed that there is NOT a duplicate key in my source data so I'm not sure how to get past this error. It refreshes fine locally.