Error code "Count [24]: The specified key attributes 'msdyn_name' are not defined as keys for entity 'msdyn_sustainabilityorganizationalunit"

Question

Hi,

I have been trying to import sample data in to Microsoft Sustainability Manager. Unfortunately I receive this error code.

"Count [24]: The specified key attributes 'msdyn_name' are not defined as keys for entity 'msdyn_sustainabilityorganizationalunit', which has entity keys 'msdyn_naturalkey (Not Active): msdyn_name | msdyn_alternatekey (Not Active): msdyn_origincorrelationid' No valid records were inserted."

Chat GPT suggested that I should check the key attributes for "msdyn_name". However, I can't seem to find "msdyn_name" anywhere. Is there any step that I have missed? I have followed the learning path of Sustainability Manager step by step, but still get this error code. Any help would be appreciated so I can continue the learning path before my trial period is over.

Answer 1

Hi Elena,

I have not reached out to the Azure support, but I can only agree with you. I have triple checked the entities, made sure that there was a great match with caps lock and everything between the import data and the entities entered in sustainability manager. I will give at few more shots, otherwise my trial for sustainability manager will come to an end.

Best regards,

Linus

Answer 2

Hi Linus,

thank you for the quick reply. I did the learning path preparations very often and still get the error. Did you reached out to the Azure support?

I will let you know if i make any progress.

Answer 3

Hi Elena,

Unfortunately not, I tried to import the data via an excel template instead of Power Query, but still no success. Hopefully it is an error in the learning path or the data set that microsoft need to fix.

Please keep me posted if you have any progress.

Answer 4

Hi Linus_L,

i have the same issue. Did you find a solution for the error?

Thank you in advance!

Kind Regards,

Elena

Answer 5

Hello Linus_L,

Thank you for posting in Microsoft Community.

We understand that you're experiencing issues with importing sample data into Microsoft Sustainability Manager. As we are technical support for consumer products of Office applications. We would like to recommend you reach out our dedicated team that could assist you regarding these products and services and they also have forum to consult the experts on this field.

Please use this link to reach out to them: Microsoft supported products on Q&A | Microsoft Learn

By reaching out to the Support for further assistance, they can provide more in-depth troubleshooting and help you resolve the issue.

Sincerely,

Kathy A.

Microsoft Community Moderator

MOD EDIT: Provided the link for best forum that can help the customer reach out to the experts.