This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I am using Excel 2013 64 bit... I am trying to build a relationship in Power Query. I have setup the relationship on the diagram view and have not received errors. I am trying to link 2 tables.
The problem occurs when I go to the pivot table. I immediately get a box on the field list that says create a relaitionship. When I try to bring fields into the pivot table from both tables, the values repeat across my field selection.
I try to create relationships again through the relationship window and get an error saying one of the tables has duplicate fields. I have gone back into Power Query and run both TRIM and CLEAN on the data field I am trying to link and still get the same error... I have downloaded the data in the field and do not see any duplicates. I even exported the data to excel and ran duplicate fields and did not find any. The fields that are being linked between tables are named the same and are the same type with the same length.
What else am I missing?
A family of Microsoft spreadsheet software with tools for analyzing, charting, and communicating data.
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
Hi,
Relationships are created in PowerPivot, not Power Query. Upload the workbook to OneDrive and share the download link here. Please explain clearly where the problem is.