Forum Discussion
Duplicate records preventing Appended Table populating
Thanks Ross.
I found the spot and noticed that it was using a mixture of FileSytemObject and ID fields for the relationships.
I just changed them all to the GUID field as per below. I don't know if this is the right way to do it but it seems to have done the trick.
I'm thinking that these dont need to be true relational tables as i just want the records to append. Sorry i'm not a DB person, so i'm fumbling through here a bit.
Note: I grabbed 3 'identical' tables and then created a new append table.
Yes thats a good solution. Requires lets data manipulation so its a better solution overall. You are doing it right.
To answer your direct question. You can use the Table.Key function for that
https://docs.microsoft.com/en-us/powerquery-m/table-addkey
However in reality, its likely your table relationships that a causing you some pain. Firstly just delete the relationship(s) that are causing the issue from that field, then apply your new power query changes that create the key field. Once that imports correctly, set up your table relationship(s) based on that field again in the "Model" area of Power BI.
Thanks Ross.
I found the spot and noticed that it was using a mixture of FileSytemObject and ID fields for the relationships.
I just changed them all to the GUID field as per below. I don't know if this is the right way to do it but it seems to have done the trick.
I'm thinking that these dont need to be true relational tables as i just want the records to append. Sorry i'm not a DB person, so i'm fumbling through here a bit.
Note: I grabbed 3 'identical' tables and then created a new append table.
Yes thats a good solution. Requires lets data manipulation so its a better solution overall. You are doing it right.
Great, thanks for your help Ross