Forum Discussion
Duplicate values that do not exist?
Hi kdlfarm2007
To avoid losing anything, you can create a copy of the pbix file to troubleshoot this. In the copied file, remove all the relationships between tables 'job head part cost'/'Erp PartCost' and other tables, then try to refresh. If refreshing successfully without error, try Amit's suggestion to create a table visual to show the count of each number in Column 'PartNum' in each table. If there are duplicate values, their count numbers will be larger than 1.
Additionally, do you execute any transformation on data to reduce rows in Power Query Editor? If not, you can also check the duplicate values at the data source side. If previous refreshings were all successful, this may be caused by newly added duplicate values at the data source side.
A common cause is the upper/lower case of the values. Power BI Desktop is case insensitive in the model, which may lead to duplicate values when the data source is case sensitive.
Regards,
Community Support Team _ Jing
If this post helps, please Accept it as the solution to help other members find it.
Error occurred when I tried to convert from direct query to import. Duplicate values on a column that was an identity column used as a primary key in SQL server, so I knew there were no nulls or duplicates. The duplicates were created because I merged a query and expanded a column. Apparently direct query can handle this but import can't. Removed the expanded column, converted to import, remerged the query and reexpanded the column did the trick