Forum Discussion
BHinote
5 years agoFrequent Visitor
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...
V-lianl-msft
5 years agoCommunity Support
Hi BHinote ,
It is suggested you check and manage the relationships. Remove the invalid relationships.
Made a copy of the PBIX and started to troubleshoot to see what came of it.
Try to manually modify or create table relationships in power bi desktop.
Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.