Forum Discussion

BHinote's avatar
BHinote
Frequent Visitor
5 years ago

Refresh failed - Column 'X' in Table 'Y' contains a duplicate value (This is a Invalid Error)

I have had a report that has been running on the PowerBI.com Service for many months using our on-premise gateway to access our SQL Server and until recently it has been running without issue, refres...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

Check for NULL values in your key column too.

  • BHinote's avatar
    BHinote
    Frequent Visitor
    5 years ago

    Thank you for your suggestion.   There are no NULL Values in the key column.