Desktop Refreshes - DirectQuery to Dataset - "Sequence contains more than one matching element"

amitchandak  

Thanks for the reply, but a duplicate value in a 1-M relationship would normally be more specific about the error, and usually tells you exactly which table has the duplicate and what the duplicate value is.

Also, the Master Dataset are connected to itself refreshes perfectly fine, so if there was any duplicate 1-M relationship issues within the model then the Dataset refresh itself would fail.

Also, everything refreshes perfectly fine in Service, it's only in Desktop that this error happens

It happens as soon as the refresh gets through "Evaluating", then "Creating connection in model" and then instantly throws up the error - and it's not like normal refresh errors as another dialogue box popups saying that something went wrong and to report it as an error: