locked
Errors in Power Query Refresh RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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.

    Thursday, October 30, 2014 4:32 AM

Answers