Having trouble with key

Hello danielru - you can add a new column to your table in Power Query and use the Text.NewGuid() function like so:

Key = Table.AddColumn ( Source, "Key", each Text.NewGuid(), type text )

https://powerquery.how/text-newguid/ 

Hi jennratten ,

Thanks so much for your help. I found the solution to this problem. I had to set up a key on my table as per this post:

https://powerusers.microsoft.com/t5/Microsoft-Dataverse/How-do-you-prevent-a-dataflow-from-creating-duplicates/td-p/1337669

Then I was able to select the key and it mapped automatically so working well.

Thank you again for all your help!

Regards,

Daniel